Microsoft KB Archive/92640

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

Article ID: 92640

Article Last Modified on 5/9/2003

-

APPLIES TO


 * Microsoft Access 1.0 Standard Edition
 * Microsoft Access 1.1 Standard Edition
 * Microsoft Access 2.0 Standard Edition

-



This article was previously published under Q92640



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.



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.

