Results 1 to 10 of 10
  1. #1
    Join Date
    Mar 2009
    Posts
    18

    Unanswered: Cannot Print Report in Landscape

    I can't seem to get Access 2007 to print my report in landscape. I originally created it using the wizard, then added and moved around a few things. The page setup is set to landscape, as is the printer settings. All views including print preview correctly show landscape, but when it prints I get one page with most of the report, then another page with the last 1/8th of the page, all in portrait. I have even tried moving everything very close to the left edge and shrinking the detail in design view down to 10.25. I have margins set to .25 also. What am I doing wrong?

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    See if this applies to your case=
    Microsoft Access tips: Converting to Access 2007

  3. #3
    Join Date
    Mar 2009
    Posts
    18
    I could find nothing in there that looked promising. Also I am not converting to 2007, I created the database entirely in 2007.

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Can you print in landscape with other reports; is it all reports that are being affected or just one?

    I think it might be a windows printer definition problem, but only guessing at this point.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  5. #5
    Join Date
    Mar 2009
    Posts
    18
    I just made another report just to be sure, and yes it is all reports apparently. No matter how wide I make it, how many records are on it, always prints in portrait. So if this is a windows printer definition problem, it can be fixed right? I'll go do some googling on that now and see what I come up with.

  6. #6
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    You looked and saw nothing. You're not converting an ancient version but still have the problem with your reports. See what it's said about reports and printers, may be the solution is there.

    Have a nice day!

  7. #7
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Can you print ANYTHING in landscape to that printer? Like from MS Word for example?
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  8. #8
    Join Date
    Mar 2009
    Posts
    18
    Yes I can print in landscape from other programs. Just printed a test page out in landscape from word with no problems.

  9. #9
    Join Date
    Mar 2009
    Posts
    18
    I installed a "hotfix" update from microsoft that seems to have fixed the problem. Thanks!

  10. #10
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Could you perhaps link others to it in case they may be having the same problem?
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •