Unable to set the PaperSize property of the PageSetup class

Posted on 2004-10-01
Last Modified: 2008-01-16
Can someone tell me why I am getting this error:

Unable to set the PaperSize property of the PageSetup class

on the following line:

.PaperSize = xlPaperLetter

Question by:DanielAttard
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
LVL 34

Expert Comment

ID: 12205674

That looks like an excel constant to me...

Can you post all the code..

LVL 34

Expert Comment

ID: 12205683

.PaperSize = 1

1 = xlPaperLetter in Excel
LVL 34

Accepted Solution

flavo earned 500 total points
ID: 12205765
If you are using Access 2003, i found this which should help you mate

        .Copies = 1
        .Orientation = acPRORLandscape
        .Duplex = acPRDPVertical
        .PaperBin = acPRBNAuto
        .PaperSize = acPRPSLetter
        .PrintQuality = acPRPQMedium

acPRPSLetter = 1 so the last comment should have worked too


Author Comment

ID: 12205796
Thanks Flavo.  I think my problem here relates to the fact that my default printer is not working.  I cannot see the properties of it because "the print spooler service" is not started.  once i change to a different, working default printer, it seems to work.

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

696 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