I'm working with an Access 2002 Pivot Table and I can't get it to display all the detail for a grouping.

For example, shipment value is the detail and date is the row field. To see all of the detail I have to click inside what is displayed and a vertical scroll bar appears. Then I have to scroll down to see all the records. Is there a way to force all detail to be displayed?

I much prefer the way Excel displays the detail - it just displays everything with no scroll bar needed.

Thanks in advance,