<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word"><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content=Word.Document name=ProgId>
<META content="MSHTML 6.00.2800.1106" name=GENERATOR>
<META content="Microsoft Word 9" name=Originator><LINK
href="cid:filelist.xml@01C2F2E1.88975E20" rel=File-List><!--[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-face {
font-family: Tahoma;
}
@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; }
P.MsoNormal {
FONT-SIZE: 10pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: Tahoma; mso-bidi-font-size: 12.0pt; mso-style-parent: ""; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 10pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: Tahoma; mso-bidi-font-size: 12.0pt; mso-style-parent: ""; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 10pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: Tahoma; mso-bidi-font-size: 12.0pt; mso-style-parent: ""; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"
}
P.MsoAutoSig {
FONT-SIZE: 10pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: Tahoma; mso-bidi-font-size: 12.0pt; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"
}
LI.MsoAutoSig {
FONT-SIZE: 10pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: Tahoma; mso-bidi-font-size: 12.0pt; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"
}
DIV.MsoAutoSig {
FONT-SIZE: 10pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: Tahoma; mso-bidi-font-size: 12.0pt; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"
}
SPAN.EmailStyle15 {
COLOR: black; mso-bidi-font-family: Arial; mso-style-type: personal-compose; mso-ansi-font-size: 10.0pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=EN-US style="tab-interval: .5in" bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Jeanine,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>look in the options and on the 'General' tab make
sure 'perform name AutoCorrect' is NOT selected.</FONT></DIV>
<DIV><FONT face=Arial size=2>Access is know for not savind page setup settings
for reports with this option selected. That is in A2k</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>HTH</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Bert-Jan</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=jscott@mchsi.com href="mailto:jscott@mchsi.com">Jeanine Scott</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=AccessD@databaseadvisors.com
href="mailto:AccessD@databaseadvisors. com">AccessD@databaseadvisors. com</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, March 25, 2003 10:16
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [AccessD] Reports: paper
size</DIV>
<DIV><BR></DIV>
<DIV class=Section1>
<P class=MsoNormal><SPAN class=EmailStyle15><FONT face=Arial color=black
size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><SPAN
style="mso-bidi-font-size: 12.0pt">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="mso-spacerun: yes"> </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="mso-spacerun: yes"> </SPAN>the code
below.<o:p></o:p></SPAN></SPAN></FONT></SPAN></P>
<P class=MsoNormal><SPAN class=EmailStyle15><FONT face=Arial color=black
size=2><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 face=Arial color=blue
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial"><SPAN
style="mso-bidi-font-size: 12.0pt">If Me.FilterOn = True
Then<o:p></o:p></SPAN></SPAN></FONT></SPAN></P>
<P class=MsoNormal><SPAN class=EmailStyle15><FONT face=Arial color=blue
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial"><SPAN
style="mso-bidi-font-size: 12.0pt"><SPAN
style="mso-spacerun: yes"> </SPAN>DoCmd.OpenReport
"rptCollectionsSummary", , "GroupBy = '" & Me.txtGroupBy &
"'"<o:p></o:p></SPAN></SPAN></FONT></SPAN></P>
<P class=MsoNormal><SPAN class=EmailStyle15><FONT face=Arial color=blue
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial"><SPAN
style="mso-bidi-font-size: 12.0pt">Else<o:p></o:p></SPAN></SPAN></FONT></SPAN></P>
<P class=MsoNormal><SPAN class=EmailStyle15><FONT face=Arial color=blue
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial"><SPAN
style="mso-bidi-font-size: 12.0pt"><SPAN
style="mso-spacerun: yes"> </SPAN>DoCmd.OpenReport
"rptCollectionsSummary"<o:p></o:p></SPAN></SPAN></FONT></SPAN></P>
<P class=MsoNormal><SPAN class=EmailStyle15><FONT face=Arial color=blue
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial"><SPAN
style="mso-bidi-font-size: 12.0pt">End
If<o:p></o:p></SPAN></SPAN></FONT></SPAN></P>
<P class=MsoNormal><SPAN class=EmailStyle15><FONT face=Arial color=blue
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial"><![if !supportEmptyParas]><![endif]> </SPAN><o:p></o:p></FONT></SPAN></P>
<P class=MsoNormal><SPAN class=EmailStyle15><FONT face=Arial color=blue
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial"><![if !supportEmptyParas]><![endif]> </SPAN><o:p></o:p></FONT></SPAN></P>
<P class=MsoNormal><SPAN class=EmailStyle15><FONT face=Arial color=black
size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><SPAN
style="mso-bidi-font-size: 12.0pt">Any suggestions??? It’s driving me
nuts!</SPAN></SPAN></FONT></SPAN><SPAN class=EmailStyle15><FONT face=Arial
color=blue><SPAN
style="COLOR: blue; FONT-FAMILY: Arial"><o:p></o:p></SPAN></FONT></SPAN></P>
<P class=MsoNormal><SPAN class=EmailStyle15><FONT face=Arial color=black
size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><![if !supportEmptyParas]><![endif]> </SPAN><o:p></o:p></FONT></SPAN></P>
<P class=MsoNormal><FONT face=Tahoma color=black size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: black"><![if !supportEmptyParas]><![endif]> </SPAN></FONT><FONT
color=black><SPAN
style="COLOR: black; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Tahoma color=black size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: black"><SPAN
style="mso-bidi-font-size: 12.0pt">Jeanine</SPAN></SPAN></FONT><FONT
color=black><SPAN
style="COLOR: black; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P></DIV>
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE></BODY></HTML>