ADODB Object
 
Syntax
 
long = recordsetobject.PageSize
recordsetobject.PageSize = long
 
Description
Sets or returns a long value that specifies how many records are on one page.
 
The PageSize property returns a long value that defines the maximum number of records that can be displayed on a single page in the Recordset object. You can set this property at any time, regardless if the Recordset is open or closed.
 
Some providers do not recognize this property.
 
You use the PageCount property to determine how many pages of data are contained in the Recordset object. When you set the PageSize property, the PageCount property is implicitly updated.
See Also
Example
 
objRecordset.PageSize = intPageSize
objRecordset.AbsolutePage = 1