Set Printform size to A4

Hi all,

This is my case:
I would like to print a vb form in A4 size. And I tried to do in these way:

1, Set the form size to A4 size, but failed. Cos it limited the size to my monitor's size (like 1024*768).
  e.g. form.Height = 15000
        form.Width = 12000

2, Set the Printer.Zoom, but not all the printer driver support "Zoom" function
  e.g. Printer.Zoom = 145

Is there any method to print the vb form fit to page (A4)?
Printform seems doesn't provide this function

please help!!

Ashley


ashleyyeungAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
moduloConnect With a Mentor Commented:
PAQed with points refunded (125)

modulo
Community Support Moderator
0
 
Ioannis ParaskevopoulosCommented:
Use the printer object .There is a property called PaperSize and you can set it to

Printer1.PaperSize=vbPRPSA4

or

Printer1.PaperSize=vbPRPSA4Small
0
 
ashleyyeungAuthor Commented:
Thanks jyparask,

I tried this property before, but the scale of myForm doesn't fit to A4. This property only can help to set the printer's setting.
What I want is the form I created can fit to A4 during print.

Finally, I gave up using form for printing. and replaced by data report. another question comes out.
I can't set 2 pages (with different format) in the same data report.

I have 2 different pages, data come from same datasource. the printing order should be
P.1 - P.2 - P.1 - P.2 - ..................P.2
can I add something like page break in data report?

Thanks
Ashley
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.