blank page generated at the end of MS Access reports

tallgeeze

Hey H/A,

I'm here at work and they are dropping the hammer on paper consumption we all do in the office. In my effort of lowering my own use I've been trying to figure out why in the hell does a blank page appear at the end of all my Microsoft Access reports.

Ex: I have a 10 page report, but when I print or preview there is a 11th blank page. o_O

I have fiddled, tweaked, and looked through every menu I can think of and I can't figure it out. I know I'm overlooking some simple and obvious.

Can some Access guru help me and bonk my head with the obvious hammer, please. Thanks

meeker

If it is blank, are you really consuming it? Put it back in the printer...

tallgeeze

meeker wrote: »

If it is blank, are you really consuming it? Put it back in the printer...

I do, but they are going to be installing this new printer that tracks how many pages we print regardless if we put the blank pages back in the bin.

It's only 1 page, but it adds up with all the different report I print.

rfalias

It's very likely that the report in design view is just a tiny bit too wide for they paper size, make sure no objects are stretching it too far, go to page preview and see if it adds another page.

Aumni

rfalias wrote: »

It's very likely that the report in design view is just a tiny bit too wide for they paper size, make sure no objects are stretching it too far, go to page preview and see if it adds another page.

This is possible, but I believe he would get a blank page in between every filled page if that were the case. A simple workaround is to only print pages 1-10, but I would check the report's design width like rfalias suggested, it's the easiest thing to check for now. Make sure no txt boxes or labels are stretching to 11.0000000000000000001 of an inch if it's a landscape or 8.500000000000000000000000000001 if it's portrait.

Edit: Actually, check your footer options/dimensions. Most likely after all the pages print the report footer is causing the page to be too tall.

tallgeeze

I got it figured it out now. I had my page breaks and footers too far below my last bits of data. It would creat the extra page because of the extra space.

I knew it was an obvious thing. thanks for getting my brain going, everyone.

mspencer

I was just going to add: consider editing the properties on each of those whitespace sections and enabling "can shrink". If they're blank they won't take up any space any more.