The DAP designer provides a recordset label in the navigation section of the page that includes record counts, the location of the current set within the total, and some text. You want to change the text displayed in the navigation section to something else. You can see the name of the table or query that's being navigated, but you don't know how to change the way the record counts are displayed.
Don't let the InnerText property fool you. The recordset label control also includes a RecordsetLabel property that controls how the record count is displayed. You'll need to use its special syntax, though, to get the exact display you want.
We've started with a simple page, shown in Figure 13-6 with its default recordset label. By default, a tabular page's recordset label shows the table name, number of records, and range of records currently displayed.
We'd like to change the page so that the recordset label looks like the one shown in Figure 13-7.
To change the default recordset label, follow these steps (or open 13-03.mdb to see the completed sample):
Open the page you want to change in design view.
Select the recordset label. If you're using the mouse to select the control, you'll need to click twice: the first click selects the navigation control and the second click selects the recordset label.
Display the properties sheet for the recordset label. Select the Data page to see the RecordsetLabel property.
Notice the default value for the property. In our example, it looks like this:
Customers |0 of |2;Customers |0-|1 of |2
The format has two portions, separated by a semicolon. The first portion determines what the label will look like when only one record is displayed on the page; the second portion determines what the label will look like if more than one record is displayed on the page.
Within each portion, the pipes followed by a 0, 1, or 2 are placeholders for the different record counts:
|0 represents the number of the current record or of the first record in the displayed group.
|1 represents the number of the last record in the displayed group.
|2 represents the total number of records in the entire recordset.
Change the RecordsetLabel property to look like this:
|2 Customers found. Viewing |0.;|2 Customers found. Viewing |0-|1.
Switch to page view. The recordset label should now look like the one shown in Figure 13-7.
If you're using our sample data for your page and displaying 10 records at a time, move to the last record. Because only one record is shown on the last page, the recordset label will use the first portion of the RecordsetLabel property's value to define the label's text, as shown in Figure 13-8. In fact, the first portion of the RecordsetLabel property is used both for pages where the DataPageSize property is 1 and for multirecord pages that show a single record under some circumstances.