Issue with access subreport page break

soap · Nov 4, 2018

Hi everyone.
My subreport in main report was generated from a subform and it works fine except that it does not create a page break whenever the data value gets to 10 or more it will start displaying new that on top of the existing instead of moving records to new page.

Kindly assist please. Thanks in advance

arnelgp · Nov 4, 2018

can you make it into a single report so you can force a new page if the detail has 10 records. subform/report have limited events to work with.

soap · Nov 4, 2018

soap said:
Hi everyone.
My subreport in main report was generated from a subform and it works fine except that it does not create a page break whenever the data value gets to 10 or more it will start displaying new that on top of the existing instead of moving records to new page.

Kindly assist please. Thanks in advance

Thanks for your quick response to help
The report is one single report generated from 3 tables, 2 of the tables are make up main and subform which i generated a query from. The query gave rise to the report.

soap · Nov 4, 2018

arnelgp said:
can you make it into a single report so you can force a new page if the detail has 10 records. subform/report have limited events to work with.

Please find below a screenshot of my report..
for design view:

https://snag.gy/3cA2nU.jpg

And for the output report..

https://snag.gy/tquoWJ.jpg

Issue with access subreport page break

soap

Registered User.

arnelgp

..forever waiting... waiting for jellybean!

soap

Registered User.

soap

Registered User.

Similar threads

Users who are viewing this thread