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:

  1. Open
    the form in Design mode.
  2. Double-click
    the form selector.
  3. On
    the Other tab, click the Cycle property box.
  4. Select
    Current Record.

Now you can control how Access behaves after the last tap
stop.