Results 1 to 2 of 2
  1. #1
    FriQenstein is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jan 2019
    Posts
    98

    Sizing issues with Reports - Printing and Exporting

    Greetings all,



    I'm in the process of trying to finalize my DB and get all the formatting looking nice.
    However, when I attempt to Export a report to a file, or even print it, the width of the report is always stuck at 13.6458"
    I cannot figure out how to reduce this to a standard 8.5"x11".

    The page layout is set to landscape, and 8.5x11 in page layout. However while in design view of the Report, even if I drag the edge of the report (the white space of the page) and resize it, it always snaps back to 13.6458"

    I have even tried to edit this number manually in the Propery Sheet, but it will not allow anything smaller than 13.6458"

    I've gone through several searches, and everyone seems to have the same response which doesn't reflect any fix for my issue. Everyone suggests using the Page Setup in print preview and whatnot, which I've attempted, but the darn thing just keeps reverting back to 13.6458" width.

    Ideas?
    Thanks.

  2. #2
    FriQenstein is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jan 2019
    Posts
    98
    Resolved!
    Turns out there were some blank hidden cells in the Footer that were extending to the far right... for some reason it was generated with the Report layout and I just happened to click in the white space by accident and found them.
    Deleted the blank cells and everything lines up accordingly.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Printing Issues
    By BradReynolds in forum Access
    Replies: 2
    Last Post: 06-11-2015, 11:09 AM
  2. Printing form record issues
    By rmohebian in forum Access
    Replies: 3
    Last Post: 03-06-2011, 02:33 PM
  3. Printing form record issues
    By rmohebian in forum Forms
    Replies: 0
    Last Post: 03-03-2011, 01:17 PM
  4. Printing Issues
    By jlclark4 in forum Forms
    Replies: 2
    Last Post: 01-12-2011, 12:15 PM
  5. printing issues
    By dmmartin in forum Programming
    Replies: 2
    Last Post: 05-29-2009, 08:22 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums