Results 1 to 2 of 2
  1. #1
    jackrabbit1962 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2013
    Posts
    3

    Problem with paper size on a report

    My Access 2010 application has many reports. On almost every report, the user can select a new paper size. This paper size is remembered, so the next time the user selects the same report, he no longer have to set the paper size (I guess this is the default behavior for Access programs).

    One report does not behave properly. This report is a LEGAL size report. EVERY times the user selects this report, it prints on LETTER size, so the form is split in two pages. If the user selects teh LEGAL size paper, it works, but the next time the report defaults back to LETTER size paper.

    I checked everywhere in the code, nowhere the paper size is set. In development, I selected the report, I changed the paper size to LEGAL, I ran the report. The next time I check the paper size of the report, it is back as LETTER size.

    After my OpenReport statement, I tried manally setting the paper size with "Reports(xxx).Printer.PaperSize = acPRPSLegal" but my report still defaults to LETTER size paper.



    I have been searching every possible solutions for the entire day and ran out of options.

    I am an experienced programmer, but I am new to ACCESS programming, I did not write this application.

    What I am missing?

  2. #2
    jackrabbit1962 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2013
    Posts
    3
    Looks like nobody ever created a report in Access ???

    What is is exact method I should use to define the default paper size when I develop my report?

    Is there an option that allows or prevents the end user from changing that default paper size?

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

Similar Threads

  1. Cannot change paper size...
    By Snowball in forum Reports
    Replies: 1
    Last Post: 01-31-2012, 07:14 AM
  2. Replies: 3
    Last Post: 10-27-2011, 11:39 AM
  3. Paper size problem
    By Jack Sheet in forum Reports
    Replies: 4
    Last Post: 07-15-2011, 12:12 PM
  4. Replies: 0
    Last Post: 03-06-2010, 01:11 PM
  5. print report on paper for image
    By gromit95 in forum Reports
    Replies: 11
    Last Post: 01-12-2010, 08:09 AM

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