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

Posted on 2007-07-23
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.
Question by:rgagli1
    LVL 1

    Author Comment

    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.
    LVL 77

    Accepted Solution

    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.
    LVL 1

    Author Comment

    I figured it out.  I needed to change the margins in Access.  It works fine now.  Thanks

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    This article is a continuation or rather an extension from Cascading Combos ( and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
    Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

    761 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

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now