Share via


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

See Also

Concepts

Form Object Members

Form Object