[AccessD] Reports: paper size

Jeanine Scott jscott at mchsi.com
Tue Mar 25 15:16:39 CST 2003


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030325/b0e5a289/attachment.html>


More information about the AccessD mailing list