Edit

Share via

EditMode property (ADO)

  • Article

Applies to: Access 2013, Office 2013

Indicates the editing status of the current record.

Return value

Returns an EditModeEnum value.

Remarks

ADO maintains an editing buffer associated with the current record. This property indicates whether changes have been made to this buffer, or whether a new record has been created. Use the EditMode property to determine the editing status of the current record. You can test for pending changes if an editing process has been interrupted and determine whether you need to use the Update or CancelUpdate method.

See the AddNew method for a more detailed description of the EditMode property under different editing conditions.

When a call to Delete does not successfully delete the record or records in the data source (due to referential integrity violations, for example), the Recordset will remain in edit mode (EditMode = adEditInProgress). This means that CancelUpdate must be called before moving off the current record (with Move, NextRecordset, or Close, for example).

Note

EditMode can return a valid value only if there is a current record. EditMode will return an error if BOF or EOF is true, or if the current record has been deleted.