AbsolutePage

This property specifies which page to move for a new current record.

Syntax

var = recordset.AbsolutePage

Return Values

Returns a Long value from 1 to the number of pages in the Recordset object (PageCount).

Remarks

Use the AbsolutePage property to identify the page number on which the current record is located. Use the PageSize property to logically divide the Recordset object into a series of pages, each of which has the number of records equal to PageSize, except for the last page, which may have fewer records.

Like the AbsolutePosition property, AbsolutePage is one-based and equals 1 when the current record is the first record in the recordset. Set this property to move to the first record of a particular page. Obtain the total number of pages from the PageCount property.

AbsolutePage supports three special values. The following table shows the values and their description.

Constant Value Description
adPosUnknown -1 The recordset is empty, the current position is unknown, or the provider does not support the AbsolutePage property.
adPosBOF -2 The current record pointer is at BOF; the BOF property is True.
adPosEOF -3 The current record pointer is at EOF; the EOF property is True.

Example

The following code example sets the constants for the AbsolutePage property.

Const adPosUnknown = -1
Const adPosBOF = -2
Const adPosEOF = -3