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 Required. An expression that returns one of the objects in the Applies To list.


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


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