ACC: How to Take a Control Out of the Tab Order

• Microsoft Access versions 1.0, 1.1, 2.0

SUMMARY

Microsoft Access version 2.0 has a TabStop property that you can use to remove a control from the tab order. Microsoft Access version 1.x does not have this property, but you can use one of the methods described below to remove a control from the tab order.

MORE INFORMATION

Method 1

Add the control to the form header or footer. Each section on a form has its own tab order, so the form user would have to explicitly move from the detail section to the header or footer to use the control.

Method 2

Add an unbound, hidden text box to the tab order before the control. Set the text box's OnEnter property to a macro that selects the first control on the form.

This solution is one that FormWizards also use. Put all of your regular controls in the detail section of the form first in the tab order, then add an unbound, hidden text box to the form, and finally add any buttons to the form. In the OnEnter property of the hidden text box, use a macro to set focus to the first of your regular controls.

REFERENCES