Results 1 to 3 of 3
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Fix margin and column values for all reports (Access 2003)

    I have a client that prints many different label reports. Each time they create a new report they have to adjust the margins and column tab options in the page setup dialog for that report. Is there a way to ensure that page setup settings remain fixed at the clients values for ALL label reports they create?
    TX
    Regards,
    Rudi

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Fix margin and column values for all reports (Access 2003)

    You can specify an existing report as the template for *all* new reports in the Form/Report tab of Tools | Options...
    However, this doesn't apply to reports created with a wizard, and moreover, I don't think you can set a default for label reports only.
    The easiest workaround might be to copy/paste an existing label report, then edit the copy.

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Fix margin and column values for all reports (Access 2003)

    OK TX.
    The person prefers the wizard, but I can show her how to base a new report on an existing one, and then just modify the source query.
    Regards,
    Rudi

Posting Permissions

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