VBA controlled margins

[jurgen]

How can I control the margins on report using VBA,
setting the left,right,top,bottom margin, everytime
a open a report.

Problem is, that my margins keep changing because very
report has a different printer to put it on paper.

Any suggestions, thanx very much already

Jurgen

 

[llkhoutx]

Once you set the margins for a report in Access, they are set, regardless of the margins in other reports.

If you think that you need to set the margin every time you open a report, use Sendkeys (see the Help menu)

 

[jurgen]

The problem is a little bit complicated than that, If you set te margins, then there is no problem. But we use different printers for different reports, and if you print a report an another one may lose their settings. It does'nt happen every time but 3 out of 10 it gives this problem.

JJ :->