Display more Pivot Table detail rows?

  • Thread starter Thread starter JaxScott
  • Start date Start date
J

JaxScott

In my Pivot Table detail area, it displays a maximum of 15 records
before it requires a vertical scroll bar to get to the other records.
Is there a way to increase/decrease the number of rows of record
details displayed? I'd like to display 20 rows instead of 15, for
example.

Thx
 
Here' the code I use successfully to display more line of data:

Private Sub Form_Open(Cancel As Integer)
Dim pTable As OWC10.PivotTable
Dim pTableView As OWC10.PivotView

DoCmd.OpenForm "Schedule Pivot", acFormPivotTable
Set pTable = Forms("Schedule Pivot").PivotTable
Set pTableView = pTable.ActiveView
pTableView.DetailAutoFit = False
pTableView.DetailMaxHeight = 330
pTableView.DetailRowHeight = 15
End Sub


Hope this helps.
 
Back
Top