EOF Property

Applies To:

Recordset object


Tells whether the current record is the last record of the recordset


BOOL/Boolean Recordset.EOF


NOTE: Currently EOF is true when the current is the last record, not after the last record.


This VB example displays a message box if the current record is the last of the Recordset.

Dim RecSet As Object     'Recordset object

If (RecSet.EOF) Then 
    MsgBox ("This is the last record.")   

End If

See Also:

BOF Property

2005 CambridgeSoft Corporation. All Rights Reserved. Privacy Statement
Tel  800 315-7300 / 617 588-9300     Fax  617 588-9390     Email   info@cambridgesoft.com
CambridgeSoft Corporation, 100 CambridgePark Drive, Cambridge, MA 02140 USA