Setting print margins with vba

[jurgen]

Hi,

I'm trying to set the page margins by using vba, the problem we have is not so complex I think.:
We have several different printers in our office and each
printer has his papertypes or labels. Now everytime we edit a report and we forget to select the correct printer before we edit it, the margins of the paper will be restored to the default of access, so everytime we edit the margins change.

Can someone help us, so that we can set the correct margins even better, the correct printer, page and margins ...

Regards


Jurgen

 

[dcrosier]

Were you able to figure this one out? I am having almost the same problem. I am calling a report from a form utilizing a command button that is executing a VBA statement. The command button statement is resetting the margins on the report to Access' standard rather than the properties of the report itself. I am trying to find the papersize or margin properties so that I can add them into the VBA code.

Any help you can provide, is GREATLY appreciated.

Thanks.
dcrosier@nhwichita.com