Page Break in Report Headers

[JonathanT]

Is it possible to place a page break in a report header? The normal page break control does not work. I have Access 2003

[boblarson]

What exactly are you needing to break at? Putting a page break in a report header sounds very strange, so a little more information as to what it is you are really trying to accomplish would be helpful. And if possible, maybe even upload a screenshot or two to let us see what you are talking about.

[JonathanT]

I have 30 subjects that have calculated fields for each quarter for two years. The 30 subjects will not fit on one header so I currently have two reports and would like one. Pdf is attached

[boblarson]

Sorry, I'm a bit confused still with what you are saying. What do you mean that you have 30 subjects that won't fit on one header? And the sample is a bit confusing since it is just 7 pages of the same thing.

So forgive me for asking to post a screenshot of the report in design view so we can see how it is set up currently. Also, your font sizes can be made smaller to fit more on the page if things need to be kept more together.

[JonathanT]

Here is a view of the design view and a brief explantion.

Thanks for your patience

[boblarson]

So, why are you using the page header? You can't page break on a page header because, by definition, the page header will appear in full on each page.

So, perhaps if you create your own custom group in the sorting and grouping - just use

=1

as the name in that and then you can put them in that header. And you could include a section footer and put the other controls there. Then you could set both the header and footer's FORCE NEW PAGE to AFTER SECTION and see if that works for you.

[JonathanT]

Thanks. That gave me the report I need except now what should be a two page report is 306 pages. The first two pages repeat themselves until the report is 306 pages.

I've set the "Repeat Section" property to "No" on both headers. Any ideas on how to fix this?

[JonathanT]

The solution is to remove the recordsource from the report. I have calculated fields in the report that point to a table and the report was bound to the same table. Once I removed the recordsource the report prints the correct number of pages

[boblarson]

Glad you figured it out. Sometimes it is more memorable when you figure it out on your own.