Move between records or fields

ShowMove between fields of the current record in datasheet view, form view, or page view

You can move to a specific field either by clicking it, or by pressing TAB or SHIFT+TAB.

ShowMove between records by using navigation buttons in a datasheet or form

The navigation buttons are located at the bottom of the window in Datasheet (Datasheet view: A view that displays data from a table, form, query, view, or stored procedure in a row-and-column format. In Datasheet view, you can edit fields, add and delete data, and search for data.) or Form view (Form view: A view that displays a form to show or accept data. Form view is the primary means of adding and modifying data in tables. You can also change the design of a form in this view.). You can use these buttons to move quickly between records.

Record navigation buttons

Callout 1 Click to move to the first record
Callout 2 Click to move to the previous record
Callout 3 Type the number of the record you want, and then press ENTER to move to a specific record
Callout 4 Click to move to the next record
Callout 5 Click to move to the last record
Callout 6 Click to add a record

ShowMove between records by using navigation buttons on a 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 (Datasheet view: A view that displays data from a table, form, query, view, or stored procedure in a row-and-column format. In Datasheet view, you can edit fields, add and delete data, and search for data.).

  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.

 
 
Applies to:
Access 2003