Count Property (Microsoft Access)

Count Property

See Also         Example         Applies To

You can use the Count property to determine the number of items in a specified collection.

Setting

The Count property setting is an Integer value and is read-only in all views.

You can determine the Count property for an object by using a macro or Visual Basic.

Remarks

For example, if you want to determine the number of forms currently open or exisiting on the database, you would use the following code strings:

'Determine the number of open forms.

forms.count

'Determine the number of forms (open or closed)
'in the current database.

currentproject.allforms.count