BOF

Returns a Boolean value indicating if the current record position is before the first record.

 

The BOF property returns a Boolean value that indicates if the current position in a Recordset object is just before the first record. If True, you are at BOF. If False, you are at or beyond the first record, but still inside the Recordset.

 

The companion EOF property returns a Boolean value that indicates if the current position in a Recordset object is just after the last record. If both the BOF and EOF properties are True, then there are no records in the Recordset.

 

If you are at BOF, then you should not call the MovePrevious method. If you do, an error will be generated since there cannot be a previous record.

Recordset, EOF.