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!
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!