Pivot Table Access 2010

[kennedymr2]

I am having a slight problem wit Access 2010 and Pivot Table.

When the amount of data in a "GROUPING" exceeds a certain size, it only visually displays a small number of items, and to look at data furthur down, it has a scroll bar on the right.

Ie is a scroll bar on the right of the group cells..not the scroll bar for the whole table.

Is there any way to tell the pivot to "expand" the data so that all items display (ie without a scroll bar )

Appreciate any help

Regards Kennedymr2

 

[kennedymr2]

I believe i have found the answer ..

Private Sub Form_Open(Cancel As Integer)
e
Set pTable = Forms("Pivot1").PivotTable
Set pTableView = pTable.ActiveView
pTableView.DetailMaxHeight = 200
End Sub