Textbox is being skipped despite code setting focus

[sandal]

Hi all,

I have a BeforeUpdate event for a number of textboxes. My code is as follows:

Please Login or Register  to view this content.

Ths last If statement adds a zero in front of a number less than 10 automatically when the user tabs out of the textbox which works perfectly, the only problem being the next textbox (in this case txtmm) is skipped and the focus is set on the textbox after this!

All my TabIndex are set in correct order. MaxLength is set to 2 and AutoTab is set to True for these textboxes.

Any help is appreciated.

[xladept]

Hi sandal,

How does it know what txtmm is?

[coreytroy]

Is

Please Login or Register  to view this content.

a type-O is it

Please Login or Register  to view this content.

?

[sandal]

txtdd and txtmm are names of textboxes on the userform. I had the maxlenght property set to 2 so it would autotab if the number entered met my requirements. If the length of the textbox was 1 (i.e. a number less than 10) and the user manually tabbed, I wanted a zero automatically added to the front to make the length 2 then tab to the next textbox.

I have figured out a way to make this work now. I have taken off AutoTab (But still keeping the TabIndex order) and created some change routines for my textboxes. e.g:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

This is now working

[xladept]

Glad you got it figured out!