BOF Property

See AlsoproBOFSee                 ExampleproBOFEx>Low

Applies To

Table object5RHH0MW, Dynaset object25TLT8, Snapshot objectHBYSUX.


After using the MovePrevious method, indicates whether the current record1BNJB8X position is before the first record in a recordset.  Not available at design time; read-only at run time.




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.



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

IntegerDOKXHY (Boolean)