SubForm.TabStop property (Access)

Use the TabStop property to specify whether you can use the Tab key to move the focus to a control. Read/write Boolean.

Syntax

expression.TabStop

expression A variable that represents a SubForm object.

Remarks

This property doesn't apply to 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.

Setting Visual Basic Description
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.

Example

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.