AllowPivotTableView Property [Access 2003 VBA Language Reference]

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

Applies to | Form Object

See Also | AllowDatasheetView Property | AllowFormView Property | AllowPivotChartView Property