Microsoft ActiveX Data ObjectsMicrosoft ActiveX Data Objects*
*Contents  *Index  *Topic Contents

PageSize Property - ADO

Indicates how many records constitute one page in the Recordset.

Applies To

Recordset

Settings and Return Values

Sets or returns a Long value, indicating how many records are on a page. Default is 10.

Remarks

Use the PageSize property to determine how many records make up a logical page of data. Establishing a page size allows you to use the AbsolutePage property to move to the first record of a particular page. This is useful in web-server scenarios when you want to allow the user to page through data, viewing a certain number of records at a time.

This property can be set at any time, and its value will be used for calculating where the first record of a particular page is.

Examples

AbsolutePage, PageCount, and PageSize Properties Example (VB)

Up Top of Page
© 1997 Microsoft Corporation. All rights reserved. Terms of Use.