[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Need a different paper size for Printer to print a report in Access 2003

Posted on 2007-07-23
3
Medium Priority
?
473 Views
Last Modified: 2013-11-28
The paper size I need is not available for a particular printer IBM Proprinter XL.  I am trying to print out vouchers on an IBM printer.  The printer gives me the option to choose the following paper sizes: A3, A4, B5 (JIS), Fanfold 8 1/2 x 12 in, Legal, Letter and US Std Fanfold.  The paper size we are using is 8 1/2 x 3 1/2.  I can choose one of the fanfold sizes but it prints 1 voucher per page.  Is there a way to choose another paper size (or maybe create something) so that we will not waste paper?  We are printing out these vouchers in Access 2003.  I think if it is possible to create another paper size, this should work fine.
0
Comment
Question by:rgagli1
  • 2
3 Comments
 
LVL 1

Author Comment

by:rgagli1
ID: 19547839
I found something in Windows to go into the Printer Server and create a new page size.  I did this for my paper size 8.5 x 3.5.  But in Access it now gives me an error that says "The section width is greater than the page width, and there are no items in the additional space, so some pages may be blank.  I checked my Access report and the dimensions are 8.5 x 3.5.  Any idea why this is not printing to this?  I see 2 extra pages printed.
0
 
LVL 77

Accepted Solution

by:
peter57r earned 500 total points
ID: 19548146
Your visible report width in Access does not include the margins.
You must restrict the visible report width to the available print width - that is, the page width minus the margins.
0
 
LVL 1

Author Comment

by:rgagli1
ID: 19548672
I figured it out.  I needed to change the margins in Access.  It works fine now.  Thanks
0

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses
Course of the Month20 days, 13 hours left to enroll

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question