Microsoft KB Archive/92640

From BetaArchive Wiki

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.

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

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