Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    St. Charles, Illinois
    Thanked 0 Times in 0 Posts

    Lock in Landscape on report (Access 2000)

    Before my report macro prints I need to lock in whether the report is portrait or landscape. I do this in Excel with no problem. Is there a code I can input that will make the report print in landscape. Quite often it jumps to portrait. Also, I need to lock in that all margins are .5. Is there a way to lock that in? The report keeps jumping back to a one inch margin. I have followed several threads and not come up with an ansswer. Thank you.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: Lock in Landscape on report (Access 2000)

    Make sure that you turn OFF "Track name AutoCorrect info" in the General tab of Tools | Options... If this setting is ON, it is known to make reports lose their page settings.

    Note: this is a database-level setting, you must turn it of in each database seaprately. There is no way (unfortunately) to make OFF the default setting.

    It is possible to set page orientation and margins in code, using the PrtMip property (look it up in the online help for Access VBA), but it is very inconvenient, for you have to open the report in design view in order to change the print settings.

Posting Permissions

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