Tab Stop Settings are Overridden by Access

[Cheese]

I'm using the "Order Entry" template supplied with Access.

I rearranged the fields on one of the forms, so the Tab Stop settings were
disrupted. I attempted to re-configure these Tab Stops with no luck. See the
screen shot below:

http://img157.imageshack.us/img157/2153/accessmq8.gif

The tab stop will not start in the upper lefthand text box named "Company".
Instead, it goes to the Billing Address instead. I even manually numbered
everything, starting with Company as 1.

Access, then - all by itself - reduces each Tab Stop setting by one,
changing Company from 1 to 0, Billing Address from 2 to 1, and so on...

How can I fix this?

 

[tina]

Access, then - all by itself - reduces each Tab Stop setting by one,

changing Company from 1 to 0, Billing Address from 2 to 1, and so on...

you don't. most, if not all, indexes in Access are zero-based; so the first
control in a form's TabIndex will have a value of zero (0). the easiest way
to set up the tab order in a form is to click the Tab Order button on the
toolbar (or click View | Tab Order on the menu bar), in design view, and
work with the controls list in the box, rather than manually changing the
TabIndex property of each control.

hth

 

[Cheese]

Thanks for the reply, but I already tried doing what you said.

The "Company" field, which I want first in the tab order - is at the top of
the list. Yet, it does not start in this order. When opening the form, it
goes directly to the second field on the tab order list, which is numbered 1.
It ignores the Company field and its "0" value.

 

[Dirk Goldgar]

Thanks for the reply, but I already tried doing what you said.

The "Company" field, which I want first in the tab order - is at the
top of the list. Yet, it does not start in this order. When opening
the form, it goes directly to the second field on the tab order list,
which is numbered 1. It ignores the Company field and its "0" value.

First check what Access thinks is the tab order, by doing what Tina
suggested: View -> Tab Order... If that shows Company at the top of
the list, then check that text box's property sheet to see if it's
enabled or not -- the Enabled property is on the Data tab of the
control's property sheet. If it's enabled and first in the tab order,
then check for code or a macro in one of the form's events that sets the
focus (using the control.SetFocus method, the DoCmd.GoToControl method,
or the GoToControl macro action) to the Billing Address control.

 

[tina]

and to add to Dirk's suggestions, also check the Company control's Tabstop
property - make sure it's set to Yes. also, if the Company control is in the
form's Header section, and the other controls are in the Detail section,
then the tab order will be separate for the two sections, and focus won't
land on the Company control when you open the form unless you explicitly
move it there with code or a macro.

hth

 

[Dirk Goldgar]

and to add to Dirk's suggestions, also check the Company control's
Tabstop property - make sure it's set to Yes.

Good point, Tina. I hadn't thought of that one, and it may well be the
culprit.