Dirty Property [Access 2003 VBA Language Reference]
You can use the Dirty property to determine whether the current record has been modified since it was last saved. For example, you may want to ask the user whether changes to a record were intended and, if not, allow the user to move to the next record without saving the changes. Read/write Boolean.
expression Required. An expression that returns one of the objects in the Applies To list.
The Dirty property uses the following settings.
|True||True||The current record has been changed.|
|False||False||The current record has not been changed.|
This property is available in Form view and Datasheet view.
When a record is saved, Microsoft Access sets the Dirty property to False. When a user makes changes to a record, the property is set to True.
The following example enables the
btnUndo button when data is changed. The UndoEdits( ) subroutine is called from the AfterUpdate event of text box controls. Clicking the enabled
btnUndo button restores the original value of the control by using the OldValue property.
Sub UndoEdits() If Me.Dirty Then Me!btnUndo.Enabled = True ' Enable button. Else Me!btnUndo.Enabled = False ' Disable button. End If End Sub Sub btnUndo_Click() Dim ctlC As Control ' For each control. For Each ctlC in Me.Controls If ctlC.ControlType = acTextBox Then ' Restore Old Value. ctlC.Value = ctlC.OldValue End If Next ctlC End Sub