This table shows which Move methods are allowed with different combinations of the BOF and EOF properties.Īllowing a Move method does not guarantee that the method will successfully locate a record it only means that calling the specified Move method will not generate an error. 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. 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 open a Recordset object containing no records, the BOF and EOF properties are set to True (see the RecordCount property for more information about this state of a Recordset). If either the BOF or EOF property is True, there is no current record. The EOF property returns 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. The BOF property returns True (-1) if the current record position is before the first record and False (0) if the current record position is on or after the first record. Use the BOF and EOF properties to determine whether a Recordset object contains records or whether you have gone beyond the limits of a Recordset object when you move from record to record. The BOF and EOF properties return Boolean values.

BOF Indicates that the current record position is before the first record in a Recordset object.ĮOF Indicates that the current record position is after the last record in a Recordset object.

Download bof ii