AllowPivotTableView Property

Microsoft Access Visual Basic

AllowPivotTableView Property

       

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

expression.AllowPivotTableView

expression   Required. An expression that returns one of the objects in the Applies To list.

Remarks

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

Example

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

Forms(0).AllowPivotTableView = True
DoCmd.OpenForm FormName:=Forms(0).Name, View:=acFormPivotTable