Posted 29 November 2017, 5:19 am EST
I have a report that can be 40 pages+ with many subreports. In the Detail_Format() there are shapes to split the data up and within those shapes we have a label that labels the data in the following section. New section gets a shape and a label and data below and so on. The problem is that I need to create a page break in Detail_Format() before I get to one of those shapes because the page break is happening right after the shape and therefore the data is on the next page.
I have tried moving controls down the report several pixels (which would be the easiest, and may be the only way), but below that it creates problems with the subreport spacing. Can PageBreak be utilized in Detail_Format() to create a a page break at an arbitrary point?