Form.DataChange Event (Access)
Occurs when certain properties are changed or when certain methods are executed in the specified PivotTable view.
Syntax
expression .DataChange(Reason, )
expression A variable that represents a Form object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Reason |
Required |
Long |
A PivotDataReasonEnum constant that indicates the reason that this event was triggered. |
Return Value
nothing
Example
The following example demonstrates the syntax for a subroutine that traps the DataChange event.
Private Sub Form_DataChange(Reason As Long)
If Reason = OWC.plDataReasonDisplayCellColorChange Then
MsgBox "The cell display color was changed."
End If
End Sub