-
1
- #1
Hello
Is it possible in access via code or a macro ... to change the standard
margins of access in page-setup? I want to change the 24.99 into 20.00
without everytime going to file - page setup etc..... I need this so my
reports print out fine.
I tried this
Application.SetOption "Left Margin", 1 'This will set default margin to
one inch. Do the same thing for the other margins.
It worked, but not where it should
. The setoption... has
changed my settings in print margins in general options. I want to change
the page-setup of a report when it loads. This so I can print more data on
a sheet of paper in a horizontal way. The report setting for page-setup
are 24,99. Everytime I run my application on another pc, access uses these
default settings. I like to change that automatically when I run my prog.
I also tried the PrtMip property in Visual Basic to set or return the
device mode information specified for a form or report in the Print dialog
box. but again just the general setting
thnx in advance!
Bart Coenen
Software-engineer
Bekaert NV
Is it possible in access via code or a macro ... to change the standard
margins of access in page-setup? I want to change the 24.99 into 20.00
without everytime going to file - page setup etc..... I need this so my
reports print out fine.
I tried this
Application.SetOption "Left Margin", 1 'This will set default margin to
one inch. Do the same thing for the other margins.
It worked, but not where it should
changed my settings in print margins in general options. I want to change
the page-setup of a report when it loads. This so I can print more data on
a sheet of paper in a horizontal way. The report setting for page-setup
are 24,99. Everytime I run my application on another pc, access uses these
default settings. I like to change that automatically when I run my prog.
I also tried the PrtMip property in Visual Basic to set or return the
device mode information specified for a form or report in the Print dialog
box. but again just the general setting
thnx in advance!
Bart Coenen
Software-engineer
Bekaert NV