PROPERTY:  Recordset::BOF

Boolean = recordsetobject.BOF

The BOF property returns a Boolean value that indicates if the current position in a Recordset object is just before the first record. If True, you are at BOF. If False, you are at or beyond the first record, but still inside the Recordset.

The companion EOF property returns a Boolean value that indicates if the current position in a Recordset object is just after the last record. If both the BOF and EOF properties are True, then there are no records in the Recordset.

If you are at BOF, then you should not call the MovePrevious method. If you do, an error will be generated since there cannot be a previous record.

Code (VBScript):
If (objRecordset.BOF = True) Then
   objRecordset.MoveFirst
End If

Copyright 1999-2001 by Infinite Software Solutions, Inc. All rights reserved.
Trademark Information