[AccessD] Reports: paper size

Jeanine Scott jscott at mchsi.com
Tue Mar 25 18:37:58 CST 2003


Thanks Marty. I added this code and hopefully that will take care of it.

Jeanine


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of MartyConnelly
Sent: Tuesday, March 25, 2003 6:05 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Reports: paper size

You could force it to Legal size with this code. Also changing your Printer
Port can cause this error.

How to Build a Visual Basic Module to Print a Report in Landscape Mode on
Legal-Size Paper
http://support.microsoft.com/default.aspx?scid=kb;en-us;302650

Jeanine Scott wrote:


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 <mailto: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/78363402/attachment-0001.html>


More information about the AccessD mailing list