Question
January 22, 2008 at 12:16 PM
jsuess

No new page at page footer in Access 2007

by jsuess . Updated 18 years, 10 months ago

I have a report: a beautiful, effective, wonderful report that works perfectly (finally!). But, nature doesn’t allow that to actually happen, so now I have a tiny problem. The report automatically creates a new page at the page footer, of course. I have a calculated control in the report footer, which I would like to see placed (logically!) right after the data it has totaled, whether I print it or export it to pdf. Instead, I end up with half a page of data, totaled by section, then blank space, then on a new page, my calculated control and graphs.

If I could delete the page header and footer sections, my problem would be solved. But, of course, I need the page header. The page footer doesn’t have a force new page option in its properties, so what do I do??? I’ve already sized it to 0, set it to show only in form view (since the problem only occurs if I print or export to pdf), and made it invisible. I can’t see it, but that doesn’t help with the page breaks. Anyone know how I can make this happen?

This discussion is locked

All Comments