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>