Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Change standard margins of page-setup of a report 1

Status
Not open for further replies.

Barco

Programmer
Jul 26, 2002
2
BE
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
 
I have always wondered the same question of how to embed my page margins into a specific report. Can you let me know if you ever get an answer?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top