Is there a way to set an Access Report to fit to one page (similar to Excel)? Depending on how many records in my sub-report, my main report can be multiple pages, and I would prefer only one.

Thank you,

No:(

Well, since that won't work, here is my next dilema.

When there are enough records in my sub-report, and I end up with multiple pages, the heading (Report Header) of my sub-report is only on the first page. The heading (Page Header) for my main report does show up on both pages. When I put the heading for my sub-report in the [Page Header] it does not show up at all.

Any suggestions?