Customize margin and orientation before printing form

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
 
A

Allen Browne

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