EOF Property

See AlsoproEOFSee                 ExampleproBOFEx>Low

Applies To

Table object5RHH0MW, Dynaset object25TLT8, Snapshot objectHBYSUX.

Description

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

Syntax

recordset.EOF

Setting

The EOF property settings are:

Setting             Description

True                 The current record position is after the last record in a recordset.

False                The current record position is on or before the last record in a recordset.

Remarks

Check the EOF property before using the MoveNext method to avoid moving beyond the limits of a recordset as you move from record to record.  If the current record is the last record, then EOF will be True after you use MoveNext.  If you use MoveNext while EOF is True, an error occurs and EOF remains True.  There is no current record when EOF is True.

When you create or open a recordset containing at least one record, the first record is the current record and EOF is False.  If the recordset contains no records, both BOF and EOF are True.

Data Type

IntegerDOKXHY (Boolean)