Customize margin and orientation before printing form

  • Thread starter Thread starter Mr. Smith
  • Start date Start date
M

Mr. Smith

Hi
I have a "print" button on my main form which prints one of several sub
forms.
I want to make sure that left and right marigin are set to 10 mm and that
the page orientation is Horizontal, before the form is printed. How will I
get "in contact" with the right properties to do this trough VBA?

Psaudo

MySubFrm Before_Print

MySubFrm.MarginLeft = 10mm
MySubFrm.MarginRight = 10mm
MySubFrm.Orentation = "Horizontal

MySubFrm.Print

Regards
Mr. Smith
 
To control how it looks when you print, create a report and print that
instead.

You can even get Access to give you something close by opening your form in
design view, and choosing Save As from the File menu to save it as a report.
Then adjust the page setup of the report (Page Setup on File menu, from
report design view).
 
Back
Top