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

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

Margin Problem with Right to Left Orientation for report 0
Right to Left Orientation Margin 3
Use Textbox.tag properties to keep values 0
Issue with Printing margins 0
Build form dynamically based on user 3
Page orientation 1
Control Page Setup of a Report through Coding 5
Page Setup with VBA 1

Top