[AccessD] Reports: paper size

Thanks – I neglected to mention that I’m working in Access97 so I don’t
think that’s my problem?

Jeanine Scott
Sr. Systems Analyst
Spindustry Systems
515-669-2074
jscott at spindustry.com

CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is
for the sole use of the intended recipient(s) and may contain confidential
information. Any unauthorized review, use, disclosure, or distribution is
prohibited. If you are not the intended recipient, please contact the sender
by reply e-mail and destroy all copies of the original message including any
attachments.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Bert-Jan Brinkhuis
Sent: Tuesday, March 25, 2003 3:54 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Reports: paper size

Jeanine,

look in the options and on the 'General' tab make sure 'perform name
AutoCorrect' is NOT selected.
Access is know for not savind page setup settings for reports with this
option selected. That is in A2k

HTH

Bert-Jan

----- Original Message -----
From: Jeanine Scott <mailto:jscott at mchsi.com>
To: AccessD at databaseadvisors. com <mailto:AccessD at databaseadvisors.%20com>
Sent: Tuesday, March 25, 2003 10:16 PM
Subject: [AccessD] Reports: paper size

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.  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  the code below.

If Me.FilterOn = True Then
    DoCmd.OpenReport "rptCollectionsSummary", , "GroupBy = '" &
Me.txtGroupBy & "'"
Else
    DoCmd.OpenReport "rptCollectionsSummary"
End If


Any suggestions??? It’s driving me nuts!


Jeanine
  _____

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030325/4b919b09/attachment-0001.html>