Tab Order

[Scientific]

Hello all,

I have a form that I would like to change the Tab order on. I have several
combo boxes with each having it's own tab index number. When the form opens
it always defaults to the first control created on the form. Is there anyway
to change this and force to tab order to go to a specific control instead?

-Sci

 

[ruralguy via AccessMonster.com]

If you open your form in design mode you can go to View>Tab Order and make
any changes you want.

 

[Rob Parker]

Several ways: you can set the Tab Index value for a particular control
directly, on the Other tab of the Property dialog. However, if you use an
existing number (which you'll need to do to change the order), then other
controls are automatically renumbered. Easier is to open the Tab Order
dialog, either via a right-click in the appropriate section of the form, or
via the View - Tab Order menu. In that dialog, just select and drag the
controls to give the order you want (in the same fashion as for the
Sorting/Grouping dialog in report design.

HTH,

Rob

 

[John W. Vinson]

Hello all,

I have a form that I would like to change the Tab order on. I have several
combo boxes with each having it's own tab index number. When the form opens
it always defaults to the first control created on the form. Is there anyway
to change this and force to tab order to go to a specific control instead?

-Sci

At least three different ways to do so.

1. Open the Form in design view; right click the little square box at the
upper left intersection of the rulers and select "Tab Order". You can either
move control names up and down by clicking and dragging them, or click the
"auto order" button to sort controls' tab orders left to right, followed by
top to bottom. (Or you can do the latter to get a reasonable starting point
and the former to tweak it to perfection).

2. Select each control in design view and change its Tab Order property.
Changing the tab order to a lower number will renumber all other
higher-numbered controls - that is, if you change the Tab Order property of
the control with the current tab order 31 to 1, it will put that one first and
change the current 1 to 2, 2 to 3 and so on.

3. Write VBA code to change the controls' Tab Order property...

 

[Scientific]

John,

So I have six combo Boxes with index numbers 1 through 6, and one List box
who's index is 0. When the form opens I want the focus to be on the List
box. How do I make that happen?

-Sci

 

[Scientific]

All Responders,

Many thanks to all responders to this thread. I figured out what I needed to
do with the following:

Private Sub Form_Load()

Me.lstMyList.SetFocus

End Sub

Thanks again all.