Microsoft KB Archive/92640
Article ID: 92640
Article Last Modified on 5/9/2003
- 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
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.
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.
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.
For more information, search for "tab order" then "Tab Order Command (Edit Menu)" or "Setting Tab Order" using the Microsoft Access Help menu.
Keywords: kbhowto kbusage KB92640