Unable to set the PaperSize property of the PageSetup class

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

Thanks.
DanielAttardAsked:
Who is Participating?
 
flavoConnect With a Mentor Commented:
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

Dave
0
 
flavoCommented:
Dan,

That looks like an excel constant to me...

Can you post all the code..

Dave
0
 
flavoCommented:
try

.PaperSize = 1


1 = xlPaperLetter in Excel
0
 
DanielAttardAuthor Commented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.