BOFAction, EOFAction Properties

Gets or sets the action to take when the beginning of the recordset is reached.

Gets or sets the action to take when the end of the recordset is reached.

object.BOFAction = [value]

object.EOFAction = [value]

Where object is an object expression that evaluates to one of the controls in the Applies To list, and value is a value or constant as described in Settings.

Settings

The following settings are available for value the BOFAction property:

Constant

(Macros)

Constant

(Scripts)

Value

Description

DataMoveFirst

nlDataMoveFirst

1

(Default) Move the cursor to the first record in the recordset.

DataStayBOF

nlDataStayBOF

2

Leave the cursor before the first record in the recordset.

DataAddNew

nlDataAddNew

3

Add a new record to the recordset and position the cursor on that record.

The following settings are available for value for the EOFAction property:

Constant

(Macros)

Constant

(Scripts)

Value

Description

DataAddNew

nlDataAddNew

3

Add a new record to the recordset and position the cursor on that record.

DataMoveLast

nlDataMoveLast

4

(Default) Move the cursor to the last record in the recordset.

DataStayEOF

nlDataStayEOF

5

Leave the cursor after the last record in the recordset.

See Also

OnBOF property | OnEOF property

Applies To

Data control


© 2004-2021 looksoftware. All rights reserved.