| title | PageCount Property (ADO) | Microsoft Docs | |
|---|---|---|
| ms.prod | sql | |
| ms.prod_service | connectivity | |
| ms.technology | connectivity | |
| ms.custom | ||
| ms.date | 01/19/2017 | |
| ms.reviewer | ||
| ms.topic | conceptual | |
| apitype | COM | |
| f1_keywords |
|
|
| helpviewer_keywords |
|
|
| ms.assetid | b601b56c-0ac4-44ee-bc91-c3d2d104f00a | |
| author | MightyPen | |
| ms.author | genemi |
Indicates how many pages of data the Recordset object contains.
Returns a Long value that indicates the number of pages in the Recordset.
Use the PageCount property to determine how many pages of data are in the Recordset object. Pages are groups of records whose size equals the PageSize property setting. Even if the last page is incomplete because there are fewer records than the PageSize value, it counts as an additional page in the PageCount value. If the Recordset object does not support this property, the value will be -1 to indicate that the PageCount is indeterminable.
See the PageSize and AbsolutePage properties for more on page functionality.
AbsolutePage, PageCount, and PageSize Properties Example (VB)
AbsolutePage, PageCount, and PageSize Properties Example (VC++)
AbsolutePage Property (ADO)
PageSize Property (ADO)
RecordCount Property (ADO)