BOF, EOF Properties

• BOF - Indicates that the cursor is currently positioned before the first record in a Recordset.
• EOF - Indicates that the cursor is currently positioned after the last record in a Recordset.

object.BOF as Boolean

object.EOF as Boolean

Use

Use the BOF and EOF properties to determine whether a Recordset object contains records or whether you've gone beyond the limits of a Recordset object when you move from record to record.

The BOF property is True if the current record position is before the first record and False if the current record position is on or after the first record.

The EOF property is True if the current record position is after the last record and False if the current record position is on or before the last record.

If either the BOF or EOF property is True, there is no current record.

If you open a Recordset object containing no records, the BOF and EOF properties are set to True. When you open a Recordset object that contains at least one record, the first record is the current record and the BOF and EOF properties are False.

If you delete the last remaining record in the Recordset object, the BOF and EOF properties may remain False until you attempt to reposition the current record.

See Also

DBOpen action

Applies To

Recordset object

---

© 2004-2021 looksoftware. All rights reserved.