<div>
Dan,<br />
<br />
That looks like an excel constant to me...<br />
<br />
Can you post all the code..<br />
<br />
Dave
</div>


Dan,

That looks like an excel constant to me...

Can you post all the code..

Dave

<div>
try <br />
<br />
.PaperSize = 1<br />
<br />
<br />
1 = xlPaperLetter in Excel
</div>


try

.PaperSize = 1


1 = xlPaperLetter in Excel

<div>
Thanks Flavo. &nbsp;I think my problem here relates to the fact that my default printer is not working. &nbsp;I cannot see the properties of it because &quot;the print spooler service&quot; is not started. &nbsp;once i change to a different, working default printer, it seems to work.
</div>


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.

<div>
<div class="content wysiwyg-content">
Can someone tell me why I am getting this error:<br />
<br />
Unable to set the PaperSize property of the PageSetup class<br />
<br />
on the following line:<br />
<br />
.PaperSize = xlPaperLetter<br />
<br />
Thanks.
</div>
</div>


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.

Unable to set the PaperSize property of the PageSetup class

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.