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.
By default, when you press [Tab] in the last field on a Microsoft Access form page, the focus moves to the first field of the next record. However, forms used mainly for data analysis, or simply to search for a specific record, should not force users to move to the next record after tabbing out of the last field. The forms should allow the user to determine where they should go next.
To set the tab stop property so that the focus moves back to the first field of the current record when [Tab] is pressed in the last field of the record, follow these steps:
- Open the form in Design mode.
- Double-click the form selector.
- On the Other tab, click the Cycle property box.
- Select Current Record.
Now you can control how Access behaves after the last tap stop.