AbsolutePage Property (ADO)

See Also   Example   Applies To   

Specifies in which page the current record resides.

Settings and Return Values

Sets or returns a Long value from 1 to the number of pages in the Recordset object (PageCount), or returns one of the following constants.

Constant Description
adPosUnknown The Recordset is empty, the current position is unknown, or the provider does not support the AbsolutePage property.
adPosBOF The current record pointer is at BOF (that is, the BOF property is True).
adPosEOF The current record pointer is at EOF (that is, the EOF property is True).

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). The provider must support the appropriate functionality for this property to be available.

Like the AbsolutePosition property, AbsolutePage is 1-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.