Reorder tab order of Tab controls

[Deutz]

Hi and thanks in advance,

I am using Access 2003 and have a form with a Tab control that has a few tabs, each with rows/columns of unbound textboxes. I am looking for a way to enable the user to navigate across and also down (via arrow and Tab keys) similar to spreadsheet navigation.

Initially, I tried setting focus to the appropriate textbox via VBA but that caused annoying screen flicker. (tried Allen Browne's solutions but still no good).

Next I tried to renumber the tab indexes of the textboxes (via VBA) either vertically or horizontally (depending on key pressed).
The first few textboxes renumber correctly but the rest get all jumbled up and renumber randomly despite my VBA.

Tried numbering from zero up and from max index down but no difference, so I really don't know what is going on here.


Thanks
Deutz

 

[Trevor G]

Welcome to the forum,

Have you looked at Setting the Tab Order? Also if you assign an Underscore to a Word the user can use Ctrl + what ever you assign to navigate through your options.

To underscore an item look to open the form in Design View then Select the Tab Control Page you want to assign an underscore to then in the Properties select Caption position the cursor to the left of the character and then use the Shift and the 7 on the keybaord this will place in & when you change the view you will see an underscore to the character you selected so then you can use the Alt + the letter.

See if that helps you out.

 

[Deutz]

Thanks Trevor,

I managed to find a solution by setting the the tabstop property of the textboxes in VBA to either true or false so that the focus moves to the correct control based on the key pressed.