Export (0) Print
Expand All
Expand Minimize

Form.DataChange Event (Access)

Occurs when certain properties are changed or when certain methods are executed in the specified PivotTable view.

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

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
Show:
© 2014 Microsoft