Form.ViewChange Event (Access)
Occurs whenever the specified PivotChart view or PivotTable view is redrawn.
Syntax
expression .ViewChange(Reason )
expression A variable that represents a Form object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Reason |
Required |
Long |
A PivotViewReasonEnum constant that indicates how the view was changed. Reason always returns –1 for PivotChart Views. |
Example
The following example demonstrates the syntax for a subroutine that traps the ViewChange event.
Private Sub Form_ViewChange(ByVal Reason As Long)
If Reason = OWC.plViewReasonShowDetails Then
MsgBox "You've opted to show details."
End If
End Sub