Results 1 to 5 of 5
  1. #1
    HelpMe is offline Novice
    Windows 10 Access 2007
    Join Date
    Nov 2020
    Posts
    2

    Can't set size of an Access report so it prints on one page?

    Hello,

    The title of this post should of been:
    Can't set size of an Access report so that it prints without printer error!

    Sorry about that!


    THE PROBLEM:

    I have Windows 10 with Access 2007 installed on my machine.

    I am trying to print a report from Access to my printer but my printer complains on the size not being correct??

    The printer I'm printing on is the default one which is set to 8.5" x 11".

    In ACCESS:

    My width of my report is 22.751cm (8.9”). My report's page set up is: Com10 Env. (4.125" x 9.5") landscape.

    The VBA command that prints the report is:

    DoCmd.OpenReport "rpt_TimeSheet", acViewNormal


    When The above VBA access command is executed, the printer signifies an error by illuminating a red light and
    I need to walk to the printer and force it by selecting the 8.5" x 11" paper size so that the report prints out.

    Therefore the report prints fine but I have to instruct the printer every time I print this report!

    Does anyone know what I am doing wrong ?



    All help is very much so appreciated

    Bob

  2. #2
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    According to my math, your report width exceeds 8.5 inches? I'd say you need to shrink the report dimensions that exceed the paper size that you're selecting on the printer, and that includes page margins for the report design.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    HelpMe is offline Novice
    Windows 10 Access 2007
    Join Date
    Nov 2020
    Posts
    2
    Hi Micron,

    I don’t understand, if my report’s width is 8.9” (see width of my report above), how could it be 8.5” too wide?? At best my report is 0.6” shorter making it fit into the printers page format of 4.125" x 9.5") landscape.???!

    I’m confused. This all worked fine in Windows 7 and now the code I was using doesn’t work anymore in Win 10. The old code made it so I can select a printer from a list box and it all worked fine! Now I bypassed that code so I resorted to one line of code which is:

    DoCmd.OpenReport "rpt_TimeSheet"

    And now I can’t seem to get the sizes right....

    If The report size is smaller than the 8.5” x 11” why is my printer complaining ??!? 😒

    Bob

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    >>My report's page set up is: Com10 Env. (4.125" x 9.5") landscape.

    Shouldn't this be "Letter" (normal 8.5" x11")? It sounds like the printer is expecting you to load envelope-size paper. The landscape setting should account for the width being greater than 8.5.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    how could it be 8.5” too wide?
    I didn't say that.
    I'll get out of pbaldy's way.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

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

Similar Threads

  1. Report with Memo field only prints on 1 page
    By Perceptus in forum Reports
    Replies: 4
    Last Post: 11-14-2017, 02:21 PM
  2. Replies: 8
    Last Post: 08-09-2013, 04:09 PM
  3. Replies: 3
    Last Post: 10-17-2011, 02:38 PM
  4. Report prints garbage after page 3
    By chrysalid in forum Reports
    Replies: 2
    Last Post: 10-03-2011, 11:05 AM
  5. report prints blank page at end of report
    By darrellx in forum Forms
    Replies: 0
    Last Post: 03-14-2006, 08:51 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