Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2002
    Posts
    2

    Unanswered: Report changing Page Setup

    For some reason, I have a report that will default back to the original page setup options when it opens. Is there a way to write an On Open Procedure to check and change these settings when needed...

    i.e. i need to change the number of columns, column width, page orientation, margins, etc.

    Any help is much appreciated

    Access 2000.

    -n-

  2. #2
    Join Date
    Feb 2002
    Posts
    403
    No, is the short answer.

    In Access 2000, open the report in design view, chose page setup, change it to how you want it, save the report and close it. This locks the page set up details.

    However, whenever you import the report to a new table you need to reset the page.

  3. #3
    Join Date
    Aug 2002
    Posts
    2
    thanks... also, this is a bug in Access fixed by Service Release 1/1a (SR-1/SR-1a)

    Knowledge Base Article Q240826

    -n-

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •