'auto tab'

[Guest]

Hi,
Any suggestions on the following would be a great help!
I have an access database, and on one of the forms i have 10 text boxes
(labelled 1-10) I want to be able to type 1 number into each text box
without having to press the tab button or click on the next text box with the
mouse. So after a number is inserted into text box 1, the next number i type
will automatically go into text box 2, and so on. I only want to put single
digit numbers into each text box.

Any suggestions as to the code i need for this??

Many thanks
Nick

 

[Van T. Dinh]

No code is needed. Check Access Help on the AutoTab Property of the TextBox
Control.

Remember for the AutoTab Property to work, you need to set the InputMask of
the TextBox, in this case, to accept a single digit (I assume you meant
digit, not number).

 

[Guest]

Hi Nick

You can the SetFocus for this afterUpdate like this


Private Sub TextBoxName_AfterUpdate()
Me.NextTextBoxName.SetFocus
End Sub


TextBoxName is the box you are inserting the number into.
NextTextBoxName is the box you want to go to after updateing TextBoxName.

Hope this helps

 

[Guest]

Hi,
Thanks for the suggestions, but none of them are working(?)
I have tried both ways, but to no joy.
Any other suggestions?

Greatly appreciated.
Nick

 

[Guest]

Ah Ha!!
A little experimenting pays off!
Using the 'on change' as apposed to 'after update' has worked!

Thanks anyway all!
Nick