Returns or sets the recordset label for the record navigation control when the page is not banded and one record is displayed, and when the page is banded and two or more records are displayed. Read/write String.
expression.RecordsetLabel
expression Required. An expression that returns a RecordNavigationControl object.
The label consists of two strings separated by a semicolon. The first string represents the label that is displayed when one record is displayed on the page, and the second string represents the label that is displayed when two or more records are displayed on the page. The label can contain the following placeholders for displaying recordset information on the page.
Placeholder | Description |
---|---|
|0 | The number of the current record, or the number of the first visible record in the group. |
|1 | The number of the last visible record in the group. |
|2 | The number of records in the recordset. |
This example sets the recordset label. If the page is banded and records 1 through 5 out of 8 are displayed, the label says "Categories 1-5 of 8." If the page is not banded and the first record is displayed, the label says "Category 1 of 8."
ProductNavigation.RecordsetLabel = _
"Category |1 of |2;Categories |0-|1 of |2"