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 its 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??? Its driving me nuts!
Jeanine
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030325/b0e5a289/attachment.html>