Form.AllowPivotChartView Property (Access)

Returns or sets a Boolean indicating whether the specified form may be viewed in PivotChart View. True if PivotChart View is allowed. Read/write.

expression .AllowPivotChartView

expression A variable that represents a Form object.

Use the AllowDatasheetView , AllowPivotChartView , AllowPivotChartView, or AllowPivotTableView properties to control which views are allowed for a form.

The following example makes PivotChart View valid for the specified form and then opens the form in PivotChart View.

Forms(0).AllowPivotChartView = True 
DoCmd.OpenForm FormName:=Forms(0).Name, View:=acFormPivotChart 

Show: