Customize a record navigation control on a data access page
- Open the data access page in Design view.
- Make sure that the record navigation control is selected. and then click Properties
on the toolbar.
- 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.
- 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
Deletes a record
- ShowFilterBySelectionButton
Filters for records that match the selected field
- ShowFirstButton
Moves to the first record
- ShowHelpButton
Displays Help
- ShowLabel Displays the information that is specified in the RecordsetLabel property
- ShowLastButton
Moves to the last record
- ShowNewButton
Moves to a new record
- ShowNextButton
Moves to the next record
- ShowPrevButton
Moves to the previous record
- ShowSaveButton
Saves the current record
- ShowSortAscendingButton
Sorts records in ascending order
- ShowSortDescendingButton
Sorts records in descending order
- ShowToggleFilterButton
Applies or removes a filter
- ShowUndoButton
Undoes the last record