Software

Prevent Access users from accidentally activating a form control

If a control on an Access form may cause an irreversible error when activated, you may want to prevent users from accidentally accessing that control. Here's how to prevent users from tabbing to a specific control.

If a control on an Access form may cause an irreversible error when activated, you may want to prevent users from accidentally accessing that control. For example, if your form includes a Delete Record button, here's how to prevent users from tabbing to the control:

  1. Open the form in Design view.
  2. Right-click the Delete Record button.
  3. Select Properties.
  4. Click the Other tab.
  5. Click in the Tab Stop property box.
  6. Click the drop-down arrow and select No.

When users press [Tab], it will stop at each control on the form in Tab Stop order, except for the Delete Record button. The user will have to intentionally click on the Delete Record button to activate it.

Miss an Access tip?

Check out the Microsoft Access archive, and catch up on other Access tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

Editor's Picks

Free Newsletters, In your Inbox