AllowPivotTableView Property

Microsoft Access Visual Basic

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