I have a report containing sub-forms that prints perfectly when all of the report sections fit on the first page.
It will also print perfectly onto the second page if the detail section is the section that overflows to the next page.
But, it all goes pear-shaped when the footer section which contains 3 sub-reports is the section that overflows to the next page.
Rows get split horizontally and/or are overlaid onto the page footer of the first page and/or onto the header of the second page.
Have searched high and low for the answer, there are many suggestions, but none that have been truly workable.
The consensus seems to be that Access cannot do it, but I'm not convinced.
A PDF (AAA) of a one page print-out which works great is attached. The footer section starts at the "Items Total".
A PDF (BBB) of an overflow example is also attached.
Have tried a few "onformat event" VBA suggestions, but none were truly effective.
It will also print perfectly onto the second page if the detail section is the section that overflows to the next page.
But, it all goes pear-shaped when the footer section which contains 3 sub-reports is the section that overflows to the next page.
Rows get split horizontally and/or are overlaid onto the page footer of the first page and/or onto the header of the second page.
Have searched high and low for the answer, there are many suggestions, but none that have been truly workable.
The consensus seems to be that Access cannot do it, but I'm not convinced.
A PDF (AAA) of a one page print-out which works great is attached. The footer section starts at the "Items Total".
A PDF (BBB) of an overflow example is also attached.
Have tried a few "onformat event" VBA suggestions, but none were truly effective.
Attachments
Last edited: