Results 1 to 2 of 2
  1. #1
    bbrazeau is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Sep 2011
    Posts
    101

    Set unbound text box with value of slider control

    I have a microsoft slider control (6.0) on my form. I also have an unbound text box on my form. I would like to have the text box hold the value the user has selected on the slider control. I tried using the "On Updated" event of the slider control to set the text box like this:

    Me.txtbox1 = Me.sldControl1.Value

    but this doesn't work. Could someone help me to acheive this? Or piont me in the right direction?


    Thank you

  2. #2
    bbrazeau is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Sep 2011
    Posts
    101
    I moved my code to the "On Exit" event of the slider control and changed it to use a Select Case statement to set the value of Me.txtbox1 and it seems to work. Is this the way it must be handled? or is there another easier way? One problem I've noticed with this method, is the text box doesn't update until the user clicks another control on the form. Also, the format of the textbox is currency and although the value updates, the dollar sign doesn't appear if the control the user clicks on is txtbox1 the user has to clicked somewhere else on the form to get the dollar sign to apppear.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Slider Control
    By Paul H in forum Forms
    Replies: 4
    Last Post: 05-05-2015, 11:17 PM
  2. Formatting Unbound Control
    By SltPhx in forum Forms
    Replies: 12
    Last Post: 08-17-2011, 01:49 PM
  3. Replies: 1
    Last Post: 07-11-2011, 04:35 AM
  4. Replies: 8
    Last Post: 05-26-2011, 07:44 AM
  5. Unbound text box truncating text
    By gddrew in forum Forms
    Replies: 0
    Last Post: 03-02-2006, 11:26 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums