<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title></title>
</head>
<body>
You could force it to Legal size with this code. Also changing your Printer
Port can cause this error.<br>
<br>
How to Build a Visual Basic Module to Print a Report in Landscape Mode on
Legal-Size Paper<br>
<a class="moz-txt-link-freetext" href="http://support.microsoft.com/default.aspx?scid=kb;en-us;302650">http://support.microsoft.com/default.aspx?scid=kb;en-us;302650</a><br>
<br>
Jeanine Scott wrote:<br>
<blockquote type="cite"
cite="midDPEMLPOPFDGDKNELEIKACEJGDAAA.jscott@mchsi.com">
<meta http-equiv="Content-Type" content="text/html; ">
<meta name="ProgId" content="Word.Document">
<meta name="Generator" content="Microsoft Word 9">
<meta name="Originator" content="Microsoft Word 9">
<link rel="File-List" href="cid:filelist.xml@01C2F2E1.88975E20">
<!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings>
<o:DoNotRelyOnCSS/>
</o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:View>Normal</w:View>
<w:Zoom>0</w:Zoom>
<w:DocumentKind>DocumentEmail</w:DocumentKind>
<w:EnvelopeVis/>
</w:WordDocument>
</xml><![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;
mso-font-charset:0;
mso-generic-font-family:swiss;
mso-font-pitch:variable;
mso-font-signature:553679495 -2147483648 8 0 66047 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
mso-bidi-font-size:12.0pt;
font-family:Tahoma;
mso-fareast-font-family:"Times New Roman";
mso-bidi-font-family:"Times New Roman";}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
{margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
mso-bidi-font-size:12.0pt;
font-family:Tahoma;
mso-fareast-font-family:"Times New Roman";
mso-bidi-font-family:"Times New Roman";}
span.EmailStyle15
{mso-style-type:personal-compose;
mso-ansi-font-size:10.0pt;
mso-ascii-font-family:Arial;
mso-hansi-font-family:Arial;
mso-bidi-font-family:Arial;
color:black;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.Section1
{page:Section1;}
-->
</style>
<div class="Section1">
<p class="MsoNormal"><span class="EmailStyle15"><font size="2"
color="black" face="Arial"><span
style="font-size: 10pt; font-family: Arial;"><span style="">I have a report
where the page setup is legal size. For some reason the paper size keeps
changing back to letter size. I open the report, set the paper size, save
it, print a few times and it’s fine. Then for some reason it changes back
to letter size again. <span style=""> </span>I open the report differently
based on how the screen is being viewed. If there is a filter on the screen
then the code opens the report with a groupby option otherwise it opens the
report as normal. I posted <span style=""> </span>the code below.<o:p></o:p></span></span></font></span></p>
<p class="MsoNormal"><span class="EmailStyle15"><font size="2"
color="black" face="Arial"><span
style="font-size: 10pt; font-family: Arial;"><!--[if !supportEmptyParas]--> <!--[endif]--></span><o:p></o:p></font></span></p>
<p class="MsoNormal"><span class="EmailStyle15"><font size="2"
color="blue" face="Arial"><span
style="font-size: 10pt; font-family: Arial; color: blue;"><span
style="">If Me.FilterOn = True Then<o:p></o:p></span></span></font></span></p>
<p class="MsoNormal"><span class="EmailStyle15"><font size="2"
color="blue" face="Arial"><span
style="font-size: 10pt; font-family: Arial; color: blue;"><span
style=""><span style=""> </span>DoCmd.OpenReport "rptCollectionsSummary",
, "GroupBy = '" & Me.txtGroupBy & "'"<o:p></o:p></span></span></font></span></p>
<p class="MsoNormal"><span class="EmailStyle15"><font size="2"
color="blue" face="Arial"><span
style="font-size: 10pt; font-family: Arial; color: blue;"><span
style="">Else<o:p></o:p></span></span></font></span></p>
<p class="MsoNormal"><span class="EmailStyle15"><font size="2"
color="blue" face="Arial"><span
style="font-size: 10pt; font-family: Arial; color: blue;"><span
style=""><span style=""> </span>DoCmd.OpenReport "rptCollectionsSummary"<o:p></o:p></span></span></font></span></p>
<p class="MsoNormal"><span class="EmailStyle15"><font size="2"
color="blue" face="Arial"><span
style="font-size: 10pt; font-family: Arial; color: blue;"><span
style="">End If<o:p></o:p></span></span></font></span></p>
<p class="MsoNormal"><span class="EmailStyle15"><font size="2"
color="blue" face="Arial"><span
style="font-size: 10pt; font-family: Arial; color: blue;"><!--[if !supportEmptyParas]--> <!--[endif]--></span><o:p></o:p></font></span></p>
<p class="MsoNormal"><span class="EmailStyle15"><font size="2"
color="blue" face="Arial"><span
style="font-size: 10pt; font-family: Arial; color: blue;"><!--[if !supportEmptyParas]--> <!--[endif]--></span><o:p></o:p></font></span></p>
<p class="MsoNormal"><span class="EmailStyle15"><font size="2"
color="black" face="Arial"><span
style="font-size: 10pt; font-family: Arial;"><span style="">Any suggestions???
It’s driving me nuts!</span></span></font></span><span
class="EmailStyle15"><font color="blue" face="Arial"><span
style="font-family: Arial; color: blue;"><o:p></o:p></span></font></span></p>
<p class="MsoNormal"><span class="EmailStyle15"><font size="2"
color="black" face="Arial"><span
style="font-size: 10pt; font-family: Arial;"><!--[if !supportEmptyParas]--> <!--[endif]--></span><o:p></o:p></font></span></p>
<p class="MsoNormal"><font size="2" color="black" face="Tahoma"><span
style="font-size: 10pt; color: black;"><!--[if !supportEmptyParas]--> <!--[endif]--></span></font><font
color="black"><span style="color: black;"><o:p></o:p></span></font></p>
<p class="MsoNormal"><font size="2" color="black" face="Tahoma"><span
style="font-size: 10pt; color: black;"><span style="">Jeanine</span></span></font><font
color="black"><span style="color: black;"><o:p></o:p></span></font></p>
</div>
<pre wrap="">
<hr width="90%" size="4">
_______________________________________________
AccessD mailing list
<a class="moz-txt-link-abbreviated" href="mailto:AccessD@databaseadvisors.com">AccessD@databaseadvisors.com</a>
<a class="moz-txt-link-freetext" href="http://databaseadvisors.com/mailman/listinfo/accessd">http://databaseadvisors.com/mailman/listinfo/accessd</a>
Website: <a class="moz-txt-link-freetext" href="http://www.databaseadvisors.com">http://www.databaseadvisors.com</a>
</pre>
</blockquote>
<br>
</body>
</html>