|
Subject:
|
Page Marings on Reports
|
|
Posted By:
|
tready
|
Post Date:
|
11/9/2005 2:48:42 PM
|
Does anyone know how to change the margins on a report via VBA??
|
|
Reply By:
|
mmcdonal
|
Reply Date:
|
11/10/2005 8:18:58 AM
|
Do a search in your VBA for "PrtMip Property"
This article will show you how to programatically set margins using twips (1440 per inch)
mmcdonal
|
|
Reply By:
|
tready
|
Reply Date:
|
11/10/2005 9:04:49 AM
|
I've tried that and cannot get it to work unfortunately.
|
|
Reply By:
|
crapanz
|
Reply Date:
|
11/11/2005 5:30:09 AM
|
May I ask why you need to play around with the Margins on the report?
Is there perhaps a simpler way, like multiple reports, or using the CanShrink property with subreports, that are bound/unbound?
Database Agreements
|
|
Reply By:
|
tready
|
Reply Date:
|
11/11/2005 8:41:59 AM
|
Yes, you may ask. I have a report that is just too big to fit on a standard landscape orientation. So by exanding the margins it will fit. I have tried to set the margins and then save the report in the design view but it does not save the margins.
|
|
Reply By:
|
crapanz
|
Reply Date:
|
11/11/2005 12:50:22 PM
|
Well, it sounds like you have a problem with the software.
If you change the margins in a report and save it, the margins should stay put.
Do you have Access 2000?
In Access2000, there is a bug fixed in SP1, or SR1 that if you have the AutoChangeFields option on then the landscape reports keep changing to letter reports. So you have to turn it off.
Database Agreements
|
