Move between records or fields

Microsoft Office Access 2003

The navigation buttons are located at the bottom of the window in Datasheet or Form view. You can use these buttons to move quickly between records.

Record navigation buttons

Callout 1 First record

Callout 2 Previous record

Callout 3 Record number

Callout 4 Next record

Callout 5 Last record

Callout 6 New record

ShowMove between records by using navigation buttons on a data access page

  • Use the navigation buttons located on the record navigation toolbar to quickly move between records or a group of records on a grouped data access page.

    Record navigation buttons

Callout 1 First record

Callout 2 Previous record

Callout 3 Record source and number

Callout 4 Next record

Callout 5 Last record

Note  If you don't see the record navigation toolbar on your page, it means one of the following:

  • All the records are displayed on the page, so the navigation buttons are not necessary.
  • The designer of the page has customized the toolbar. Look for custom instructions on how to use the page, or contact the designer.

ShowMove between fields with the Go To Field box in Datasheet view

Adding the Go To Field box makes it easier to move between fields in long records in Datasheet view.

  1. Open a table, query, form, view, or stored procedure in Datasheet view.
  2. Click Toolbars on the View menu.
  3. Select Formatting (Datasheet).
  4. Click Close.

The Go To Field box is the leftmost item on the Formatting (Datasheet) toolbar. Use it to click the name of the field that you want to move to in the current record.