ADO » Recordset » PageSize

long = recordsetobject.PageSize
recordsetobject.PageSize = long

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.


objRecordset.PageSize = intPageSize
objRecordset.AbsolutePage = 1

See Also: