Unable to see results in Text Box attached to a Spin Button

Coach Ty

Registered User.
Local time
Today, 15:46
Joined
Aug 16, 2009
Messages
64
Hi,
Was wondering if anyone has encountered this problem and how to resolve it.
I've created a form that includes text box fields attatched to spin button controls. Everything works fine with this exception:
The numbers within the text box, do not change along with clicking the spin button control. The number within the box remains unchanged. However, when I press the tab control to advance to the next text field, the number then changes to the value that had been created by the spin button control.
In other words, when clicking the spin button, the number doesn't advance, but when I tab to the next box, the number shows and has in fact advanced without me being able to see it.
So, the control and the box are working fine, I just need the number to be visible while using the control, to see the value increase.
Is there a control that I need to set, perhaps in the property sheet to achieve this?
Please let me know.
Thanks for your help.
 
Use the CHANGE event of the spin button and set the text box to the value

Me.YourTextbox = Me.SpinButton.Value
 
Hi Bob,
Thanks for you reply.
I tried to do what you said. But it hasn't resolved the issue. The number still remains unchanged in the text box, until I press the tab key.
Maybe I'm not doing it right?
Here's what I did:
I first tried to do this through the Build Event function and entered what you said as a change option. In the "Me.YourTextbox=Me.SpinButton.Value" Expression you listed, I substituted "YourTextbox" for the text box associated with the spin button. And I designated "SpinButton" as the spin button associated with the Text box, in the expression. Was this correct? I received an error code.
I then tried to enter the same expression, with the same values, into the Event Tab of the Properties sheet and it accepted the expression, however it did not resolve the issue and the text box continued to function the same.
Did I do what you advised correctly or did I make a mistake somewhere?
Thanks again for your help ...
 
Hi Bob,
I was able to open your example and it works exactly the way I'd like mine to work. However, when I tried to assign the code it keeps giving me an error, saying that I can't assign another value to the object and the it tried to run a debugging application. It got to the point where the process modified my form and it wouldn't work. So I had to go in an recreate it.
I was wondering if could have something to do with the fact that the Spin Buttons are assigned to field boxes in a table? I noticed that your text box in the example is unbound. My text boxes are already bound to fields within a table.
When I created the spin button I went into the event builder and used a
"Textbox.SetFocus" command, with the change option. When I go into the same option now and try to enter the code you gave me, I get an error code. So, I'm wondering if it could be due the fact that the spin button has already been assigned to a prior table field using a different code?
Seems like whenever it appears to be simple thing to resolve, it always ends up being more complicated ... Probably just my lack of knowledge.
Let me know if you have any ideas.
Thanks
 
The only thing I can suggest is perhaps uploading the database so I can take a look. Remember to remove any sensitive or personal data.
 

Users who are viewing this thread

Back
Top Bottom