See Also Example
Applies To
Table object, Dynaset object
Description
After using the MovePrevious method, indicates whether the current record Not available at design time; read-only at run time.
Syntax
recordset.BOF
Setting
The BOF property settings are:
Setting Description
True The current record position is before the first record in a recordset.
False The current record position is on or after the first record in a recordset.
Remarks
Check the BOF property before using the MovePrevious method to avoid moving beyond the limits of a recordset as you move from record to record.
When you create or open a recordset containing at least one record, the first record is the current record and BOF is False. If the current record is the first record, and you use MovePrevious, BOF will then be True and there will be no current record. Using MovePrevious while BOF is True produces an error and BOF remains True. There is no current record when BOF is True. If the recordset contains no records, both BOF and EOF are True.
Data Type
Integer (Boolean)