Our new Indie Games subforum is now open for business in G&T. Go and check it out, you might land a code for a free game. If you're developing an indie game and want to post about it, follow these directions. If you don't, he'll break your legs! Hahaha! Seriously though.
Our rules have been updated and given their own forum. Go and look at them! They are nice, and there may be new ones that you didn't know about! Hooray for rules! Hooray for The System! Hooray for Conforming!

blank page generated at the end of MS Access reports

tallgeezetallgeeze Registered User regular
edited September 2009 in Help / Advice Forum
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

tallgeeze on

Posts

  • meekermeeker Registered User
    edited September 2009
    If it is blank, are you really consuming it? Put it back in the printer...

  • tallgeezetallgeeze Registered User regular
    edited September 2009
    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.

  • rfaliasrfalias Registered User
    edited September 2009
    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.

    1036440-1.png
  • AumniAumni Registered User regular
    edited September 2009
    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.

    http://steamcommunity.com/id/aumni/ Battlenet: Aumni#1978 GW2: Aumni.1425
  • tallgeezetallgeeze Registered User regular
    edited September 2009
    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.

  • mspencermspencer Registered User regular
    edited September 2009
    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.

    MEMBER OF THE PARANOIA GM GUILD
    XBL Michael Spencer || Wii 6007 6812 1605 7315 || PSN MichaelSpencerJr || Steam Michael_Spencer || Ham NOØK
    QRZ || My last known GPS coordinates: FindU or APRS.fi (Car antenna feed line busted -- no ham radio for me X__X )
Sign In or Register to comment.