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).
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Print a form after changing background color and orientation 5
Printing a form with Landscape Orientation 5
displaying report margins and orientation on the form 2
Check values before form update 1
Print form before closing... 1
Trouble when printing form. All records are printed... 2
Use Textbox.tag properties to keep values 0
HP Laserjet 1012 print positioning 1

Back
Top