Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Jan 2003
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Page Setup Changes (Access 2000)

    I have created an Access 2000 report and in Page Setup, I changed the default margins and changed the page orientation to landscape. However, the new Page Setup won't stick, as when the report is opened by someone else or even myself another day, it reverts back to portrait orientation and the default margins. I certainly would appreciate any advice anyone can give me to correct this situation. Many thanks...M.

  2. #2
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Page Setup Changes (Access 2000)

    For the margins, go to Tools, Options, General to check the margin settings.
    Regards,

    Gary
    (It's been a while!)

  3. #3
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Page Setup Changes (Access 2000)

    What Gary means by "to check the margin settings" is to turn off the Name AutoCorrect checkbox 'Track name AutoCorrect info'.
    I got this information from Mark's answer in <post#=209552>post 209552</post#>
    Pat <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  4. #4
    4 Star Lounger
    Join Date
    Dec 2002
    Location
    Kitchener, Ontario, Canada
    Posts
    421
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Page Setup Changes (Access 2000)

    I have found it a good failsafe when specific page settings are required for certain reports - I had a database that needed to print triplicate carbonless receipts on a dot matrix and other reports on the laser printer - that you choose "Page Setup" from the File menu with the report in question opened, click on the Page tab of the dialogue box and select "Use Specific Printer" and specify the printer you want. Those page settings seem to be retained with none of the usual arbitrary nonsense (default settings imposing themselves) that you get otherwise. Particularly useful if you have more than one printer/printer driver set up on your computer or if you are on a network.

    Peter

  5. #5
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Altnau, Thurgau, Switzerland
    Posts
    447
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Page Setup Changes (Access 2000)

    This is my favorite Access bug (reports losing customised settings). It keeps getting fixed with service pack releases. Then the new version of Access appears and, guess what, it's back again. Turning off auto-correct can help. If all reports have the same, customised, margins then set these as the default margins for the reports in the database settings.

  6. #6
    2 Star Lounger
    Join Date
    Jan 2003
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Page Setup Changes (Access 2000)

    Many thanks to all--I very much appreciate what you did in answering my call for help so quickly. Our server is down at this time, but as soon as I can get to the database, I will try your suggestions and keep my fingers crossed that they do the trick. Again, many thanks...M.

Posting Permissions

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