Does anyone know how to change the margins on a report via VBA??

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

I've tried that and cannot get it to work unfortunately.

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

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.

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