skips controls
 

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......

--
JT

skips controls
 

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

Rick


"JT" wrote in message
...
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......

--
JT