-
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 . 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