[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 
  To: AccessD at databaseadvisors. com 
  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/88567a63/attachment-0001.html>