Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2003
    Location
    Australia
    Posts
    217

    Unhappy Unanswered: HELP! How to Fix Paper Size to A3 ?

    I got a report designed for A3 paper size.

    Every time I change the design, I have to set my default printer to one which has A3 paper, so that the A3 paper size setting does not get altered.

    But when I send the database to someone else, the paper size will be reset to A4 (probably because his Default printer has NO A3).

    How can I FIX the paper size of that report to A3 ??

    Can I do it manually or is there any VBA solution ?

  2. #2
    Join Date
    May 2002
    Location
    London
    Posts
    87
    You can set any individual report to print to a specific printer by going into the page setup while in design view.

  3. #3
    Join Date
    Jul 2003
    Location
    Australia
    Posts
    217

    Unhappy HELP!

    I know this.

    But the database user is at a DIFFERENT location.

    Also, he might CHANGE his printer later.

    All I want to do is preset the paper size, not the printer.

  4. #4
    Join Date
    May 2002
    Location
    London
    Posts
    87
    I suspect that that may be rather DIFFICULT and think you may have to MANUALLY set the printer for this report for each INSTALLATION of your SYSTEM.

    The user may also have difficulties if you keep randomly SHOUTING at him.

  5. #5
    Join Date
    Jul 2003
    Location
    Australia
    Posts
    217

    Unhappy Re: HELP

    There must be a programmatic way to do this.

    Please help.

Posting Permissions

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