Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    May 2004
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report Page Size Changes (Access 2000 SR3)

    I have one report of many of my Legal Size reports that keeps reverting to Letter Size. I open the report in Design Mode, go into <img src=/S/disk.gif border=0 alt=disk width=15 height=15>, [Page Setup], [Page], select Paper Size "Legal", and then save it. Everything works fine for a while, then the Page Size re-sets itself to Letter. Any suggestions?

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

    Re: Report Page Size Changes (Access 2000 SR3)

    Select Tools | Options... and activate the General tab. Make sure that the Track Name AutoCorrect options are OFF (cleared). Apart from causing other problems, Name AutoCorrect can make reports lose their page settings.

  3. #3
    New Lounger
    Join Date
    May 2004
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Page Size Changes (Access 2000 SR3)

    Thanks Hans,

    This database is used by several people on our network, but I went around to each and none have the Track Name AutoCorrect turned on. Could there be any other causes of this problem?

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

    Re: Report Page Size Changes (Access 2000 SR3)

    The Track Name AutoCorrect settings are not user-level settings but database-level settings.

    Another possibility is mentioned in MSKB article ACC2000: Changing Printer Port Resets Printer Setup Information.

    Fellow moderator <!profile=Charlotte>Charlotte<!/profile> has a lot of experience with controlling printer settings in code; perhaps she has additional ideas.

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Now-Luanda, Angola, Originally - Anna Bay, New South Wales, Australia
    Posts
    238
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Page Size Changes (Access 2000 SR3)

    In Page setup, make sure you have the report going to a specific printer (and obviously choose the appropriate one), not to the default printer. This solved a similar problem I had
    Steve
    Dummy from Down Under <img src=/S/flags/Australia.gif border=0 alt=Australia width=30 height=18>

  6. #6
    New Lounger
    Join Date
    May 2004
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Page Size Changes (Access 2000 SR3)

    trouble is, we have slightly different printers on different workstations: some print to HP LaserJet 5L's, some to HP LaserJet 6L's, some local and some via Windows printer sharing.

    Does anyone know how to set the report page size via a macro SETVALUE or in Visual Basic? I can just use the "hit it with a hammer" approach and set the report page size each time before I print it.

  7. #7
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Report Page Size Changes (Access 2000 SR3)

    If you design the report to use the Default printer on a workstation, rather than a specific printer, it should hold its formatting on the other machines, regardless of what their default printer may be ... unless they pick a specific printer to print to. I'm assuming here that the application is shared rather than residing on each machine, since otherwise once you set the report up for a printer, it would remember those settings.

    The VB code to manipulate printers is extensive, involves API calls and is a pain to work with and maintain. In fact, you don't manipulate the printer, you manipulate the report design in code. There is code in the Access Developers Handbook that you can adapt for this purpose. It uses the API DEVMODE structure to modify the PrtDevMode property of forms or reports. You can also find example code using the GetPrinter API call on various sites around the web.
    Charlotte

Posting Permissions

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