To all:
I have just spent several hours trying to format a report in Access 2010 so that it will print properly. Frankly, I have never worked with Access 2007 (skipped directly from Access 2003) so I can't comment on what may have changed from 2007 to 2010.
My issue was this:the first page of my report needs to show information from one table in the Detail Section of the report. Below that information is a subreport (a continuous form/report) that displays detail lines from a related table. The first page
of the report can display about 12 detail lines, and the second page of the report (without the info from the first table) can show about 20 detail lines.
The subreport has a header showing the column headings. The subreport header needs to print on every page. Some records have only a few detail lines, others have dozens, so I cannot predict in advance how many detail lines will be needed in each report.
I was encountering lots of different behavior as I worked at formatting the report: the first page would only print the info from the first table, and the detail lines would start on the second page. Or, after adding a page break after the subreport, the
detail lines would print right after the main information (desired behavior), but I would then end up with a blank page at the end of the report. Or, in one instance, 12 detail lines printed on the first page, 2 printed in the second page, and 3 more printed
on the third page.
After reading this thread, I poked around a little and discovered that in my report, I have the following sections that have formatting properties: Page Header, Detail Header, Sub Report Header, Sub Report Page Header, Sub Report Detail Header.
For each section, the following properties exist: Can Grow, Can Shrink, Keep together, Force New Page, and Auto Height. Force New Page actually has a choice of four settings. In addition, I have the option of inserting a page break in several of the sections.
So, altogether, I have about 600 formatting options I can choose, each of which may produce a different result in my report.
I suspect that this is many more formatting options than existed in earlier versions of Access, although I have not tested that theory.
Fortunately, I was able to get my report to work correctly after trying only a handful of the formatting options. In my case, the key was to remove all page breaks, shrink the size of my subreport to its smallest possible size (I had tried stretching it
to see if that would cause the pages to break properly), then going to the property sheet of the subreport and setting Can Grow to Yes.
Best of luck to all in formatting their reports. Perhaps someone will write an "Access 2010 Report Formatting Bible" that will explain in clear and understandable language what each formatting option does and how it affects the report output.