Results 1 to 2 of 2

Thread: RESOLVED: How to dynamically set report margins/layout in Access

  1. #1

    Thread Starter
    New Member
    Join Date
    Aug 2003
    Location
    Bentonville, Arkansas
    Posts
    15

    Thumbs up RESOLVED: How to dynamically set report margins/layout in Access

    I have several reports in Access that should be set up landscape, on legal paper. However, sometimes the default setup will occur and cause the report to print out incorrectly.

    I would like to set the margins and layout of each report during run-time; however, I have yet to find helpful information on how to reference the margins and layout properties of a report in VBA.

    Anyone out there know how to do that? It would be greatly appreciated!
    Last edited by jtnelso; Dec 17th, 2003 at 05:59 PM.

  2. #2

    Thread Starter
    New Member
    Join Date
    Aug 2003
    Location
    Bentonville, Arkansas
    Posts
    15

    Talking RESOLVED!

    After some serious message board searching, I have found my answer.

    In case someone reads this to find a solution, here is what I found:

    I am running Access 2000 and my report margins wouldn't "stick"...they would default back to default margins and page orientation.

    JackV has a thread titled "Access Report Question" and my problem was solved through his thread.

    In Tools | Options, under the General tab, uncheck the "Track name Autocorrect info". There is a bug in Access 2000 with this feature that somehow affects the saved report margins in reports.
    I don't understand it, but it works!

Posting Permissions

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



Click Here to Expand Forum to Full Width