TabStop Property [Access 2003 VBA Language Reference]
You can use the TabStop property to specify whether you can use the TAB key to move the focus to a control in Form view. Read/write Boolean.
expression Required. An expression that returns one of the objects in the Applies To list.
The TabStop property applies only to controls on a form, not controls on a report.
This property doesn't apply to check box, option button, or toggle button controls when they appear in an option group. It applies only to the option group itself.
The TabStop property uses the following settings.
|Yes||True||(Default) You can move the focus to the control by pressing the TAB key.|
|No||False||You can't move the focus to the control by pressing the TAB key.|
When you create a control on a form, Microsoft Access automatically assigns the control a position in the form's tab order. Each new control is placed last in the tab order. If you want to prevent a control from being available when you tab through the controls in a form, set the control's TabStop property to No.
In Form view, hidden or disabled controls remain in the tab order but are skipped when you move through the controls by pressing TAB, even if their TabStop properties are set to Yes.
As long as a control's Enabled property is set to Yes, you can click the control or use an access key to select it, regardless of its TabStop property setting. For example, you can set the TabStop property of a command button to No to prevent users from selecting the button by pressing TAB. However, they can still click the command button to choose it.
The following example disables the ability to move the focus to the "City" text box on the "Suppliers" form by using the TAB key.
Forms("Suppliers").Controls("City").TabStop = False