asked on

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

Ioannis Paraskevopoulos

Use the printer object .There is a property called PaperSize and you can set it to

Printer1.PaperSize=vbPRPSA4

or

Printer1.PaperSize=vbPRPSA4Small

ashleyyeung

ASKER

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

ASKER CERTIFIED SOLUTION

modulo

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial