How to force a new page when sub report exceeds allocated space

[EddieN1]

I have a sub report (invoice details) inside a report (invoice header and footer). The sub report is limited to a box on the pre-printed form so I set Can Grow to No. If the lines in the sub report exceed the amount of space allocated to it, it just stops formatting details (or at least I can't see them). I would like it to trigger a new page for the report and then continue printing the sub report on the next page. Any help would be appreciated.

[June7]

Does Print Preview show the correct formatting on all pages? What do you mean by 'limited to a box'? What formatting - VBA code? Do you want to provide project for analysis?

[EddieN1]

Yes, the Print Preview shows the formatting correctly on the page. When I refer to a "box", I mean that this invoice is being printed on a pre-printed invoice form. There are several boxes near the top for invoice number, date, name/address, PO number, etc. Then there is a section (the box) that is reserved for the details of the invoice. This is the box that the sub report appears in. Below the box is a place for invoice totals and a disclaimer.

The sub report prints the details in the box just fine except when there are more details than will fit in the box. When this occurs, I would like the sub report to, somehow, indicate that the main report needs to go to a new page, reprint the header information again, then when it gets to the detail "box", the sub report should pick up where it left off and print more details.

I don't have any VBA code at this time, but I'm willing to code an event if I could figure out what event fires that says the sub report has filled up the area on the page.

I appreciate your help. If I'm unclear on anything, let me know and I'll provide more details.

Eddie

[June7]

Still not able to follow your description. Probably would help to see it if you would provide the project.