|
-
Nov 25th, 2003, 06:10 PM
#1
Thread Starter
New Member
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.
-
Dec 17th, 2003, 05:58 PM
#2
Thread Starter
New Member
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|