ADO: ActiveX Data Objects

Name

Recordset.BOF Property, Recordset.EOF Property — (Versions 2.0, 2.1, 2.5, 2.6)

Synopsis

                     Boolean = recordset.BOF
Boolean = recordset.EOF

The BOF property indicates that the record pointer is located before the first record in the recordset. The EOF property indicates that the record pointer is located directly after the last record in the recordset.

Datatype

Boolean

Description

The BOF and EOF properties are both read-only.

If both the BOF and EOF properties are True, then the current recordset is empty. Using any Move method (Move, MovePrevious, MoveFirst, MoveNext, or MovePrevious) generates an error.

If both the BOF and EOF properties are False, then the record pointer can be pointing to any record within the recordset. If this is the case, you can use any of the Move methods without generating an error.

If the BOF property is True and the EOF property is False, then the record pointer is pointing to the position directly before the first record within the recordset. When this happens, you cannot use the MovePrevious method or the Move method with a negative number without generating an error.

If the EOF property is True and the BOF property is False, then the record pointer is pointing to the position directly after the last record within the recordset. When this happens, you cannot use the MoveFirst method or the Move method with a positive number without generating an error.

If you delete the last record in the recordset, the BOF and EOF properties will remain set to False until ...