RecordCount Property

Indicates the current number of records in a Recordset object.

Return Values

Returns a Long value.

Remarks

Use the RecordCount property to find out how many records are in a Recordset object. The property returns adUnknown (-1) when ADO cannot determine the number of records. Reading the RecordCount property on a closed Recordset causes an error.

If the Recordset object supports approximate positioning or bookmarks, this value will be the exact number of records in the Recordset regardless of whether it has been fully populated. If the Recordset object does not support approximate positioning, this property may be a significant drain on resources because all records will have to be retrieved and counted to return an accurate RecordCount value.

Applies To

Recordset

See Also

AbsolutePosition, PageCount