Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Microsoft Office Access
Search
Search
 
 
 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Move between records or fields
 

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 window 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 window 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 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

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 window 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.

advertisement