skips controls

[JT]

I have a user form wtih 10 textboxes where the user can enter an amount in 1
or more of the textboxes.

I am using the following code to format the textbox after the update:

Sub TB01_AfterUpdate() ' first textbox
frm_TaxEntry.TB01 = Format(TB01, "$ ##,##0.00")
End Sub

This seems to work good. The problem is if I tab out of this textbox, the
cursor moves to the 3rd textbox instead of the 2nd one. The crazy thing is
if I use the "Enter" button to exit the textbox, the cursor goes to the 2nd
one; which is what I want it to do.

How can I make the cursor go to the 2nd textbox when I tab out of the first
one?
Thanks for all of your help......

 

[Rick Rothstein \(MVP - VB\)]

Use the TabIndex property to set the numerical order for tabbing between
your controls.

Rick