Report/subreport Page break (Access 2003)

Topic

New Reply

I created a Report that has 5 sub reports(graphs) in the detail section.
From the report menu the user can select which (sub)reports they want to see(any combination of the 5).
Depending on the combination selected sometimes the subreport is split with the remainder showing on the next page.
It never takes more than 2 pages to show all the reports and up to 3 reports will fit depending on the selection.
All the Can grow and Can shrink properties are set to Yes.
I tried to code a page break but I couldn’t figure the logic for all the possible combinations that the user could select.
Is there a detail hight property that can be used to insert a break if the detail section gets past a certain height?
Or is there a better way to do this.
Thanks,
Scott

Reply | Quote

Replies

See ACC2000: Keeping Subreport or Text Box Data Together on a Page.

Reply | Quote

Thanks,
I’ll give it a try

Reply | Quote