Tab issue with form textboxes

[raw]

Hi

Just come across this issue with the tab key. Me and other users of the forms use the tab key to move the cursor from text box to text box. But with one of my forms (not tried the rest) when you use the tab key it start and textbox1, jumps to textbox2 then jumps textbox5 miss textbox3 that is under No.2....... then jumps to the command button then back up again to textbox7. Any way to cure this??

Textbox 4 is missing, i must of deleted this

RAW

[Leith Ross]

Hello raw,

Every object on a UserForm has a TabIndex property that controls the order of object focus. The index starts at zero and goes up. You can change an objects TabIndex number to alter when the object receives the focus. Click on the TextBox and look in the Properties page to see what the current TabIndex is, and check the others as well. You need to make your text boxes TabIndex numbers sequential (0,1,2,3,etc).

Sincerely,
Leith Ross

[Steel Monkey]

If you have a lot of textboxes etc on your form, an easy way of changing the tab order is go to the view menu and select tab order. You can move these up or down etc(this automatically changes the TabIndex), this saves you going through each control on the form and looking at the TabIndex and making sure theyre sequential etc