Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/92640

From BetaArchive Wiki

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.


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.


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