PivotTable Property

Microsoft Access Visual Basic

PivotTable Property

       

Returns a PivotTable object representing a PivotTable View on a form.

expression.PivotTable

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

Example

This example reports the version of Microsoft Office Web Components in use for the specified form, assuming that there is a PivotTable View on the form.

Dim objChartSpace As PivotTable

Set objChartSpace = Forms(0).PivotTable

MsgBox "Current version of Office Web Components: " _
    & objChartSpace.Version