Share via

Customize a record navigation control on a data access page

  • Article

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

  1. Open the data access page in Design view.

  2. Make sure that the record navigation control is selected. and then click Properties aa170900(v=office.10).md on the toolbar.

  3. Type values for the following properties to change them:

    • In the RecordsetLabel property, modify the strings as needed. For example, the RecordsetLabel property for a Products group level could be set to Products |0 of |2;Products |0-|1 of |2. The first string (before the semicolon (;)) represents the label that is displayed when one record is displayed on the page in Page view or in Microsoft Internet Explorer. The second string (after the semicolon) represents the label that is displayed when two or more records are displayed on the page. |0 indicates the number of the current record on a page used for data entry or the number of the first visible record in the group on a grouped page; |1 indicates the number of last visible record in the group on a grouped page; and |2 indicates the number of records in the recordset.

    • In the RecordSource property, type the name of the table or query for the group level.

  4. Set any of the following properties to True to show a button or label, or to False to remove a button or label. In Page view or in Internet Explorer, these buttons have the following functions:

    • ShowDelButton Aa156528.delrecd(en-us,office.10).gif Deletes a record

    • ShowFilterBySelectionButton Aa156528.filtselc(en-us,office.10).gif   Filters for records that match the selected field

    • ShowFirstButton Aa156528.dapfirst(en-us,office.10).gif   Moves to the first record

    • ShowHelpButton Aa156528.0984(en-us,office.10).gif   Displays Help

    • ShowLabel   Displays the information that is specified in the RecordsetLabel property

    • ShowLastButton Aa156528.daplast(en-us,office.10).gif   Moves to the last record

    • ShowNewButton Aa156528.newrecd(en-us,office.10).gif   Moves to a new record

    • ShowNextButton Aa156528.dapnext(en-us,office.10).gif   Moves to the next record

    • ShowPrevButton Aa156528.dapprev(en-us,office.10).gif   Moves to the previous record

    • ShowSaveButton Aa156528.savrecd(en-us,office.10).gif   Saves the current record

    • ShowSortAscendingButton Aa156528.sortasc(en-us,office.10).gif   Sorts records in ascending order

    • ShowSortDescendingButton Aa156528.sortdesc(en-us,office.10).gif   Sorts records in descending order

    • ShowToggleFilterButton Filter object   Applies or removes a filter

    • ShowUndoButton Aa156528.unsavrec(en-us,office.10).gif   Undoes the last record