Change paper size in code

[Daniel]

Hi All,

I have got an Access application to print large drawings to a large
priter. The drawings have three different sizes, which is
610mm*1500mm, 610mm*1350mm and 610mm*850mm. The problem is that if I
set up papersize to 610*850, the drawings with other two sizes will be
shrinked. If I set up papersize to 610*1500, every drawing print out
ok but waste a lot of paper. I am thinking put all drawings with their
size in a table and change the printer papersize setting accordingly
when it is printing. But I do not know how to change the setting in
the code. Or there is any other better way to achieve this.

Thank you for your help in advance.

Cheers
Daniel

 

[Tom van Stiphout]

On Mon, 7 Jun 2010 23:25:11 -0700 (PDT), Daniel

Check out the Printer object; it has a PaperSize property.

-Tom.
Microsoft Access MVP

 

[Daniel]

On Mon, 7 Jun 2010 23:25:11 -0700 (PDT), Daniel


Check out the Printer object; it has a PaperSize property.

-Tom.
Microsoft Access MVP







- Show quoted text -

Hi Tom,

Thank you for your reply. I know I can set up papersize with an
integer value. But these three size are all customized size and how
can I know the number of them?

Cheers
Daniel

 

[Tom van Stiphout]

On Tue, 8 Jun 2010 22:13:59 -0700 (PDT), Daniel

I believe you can first setup a custom paper size through the printer
driver.

-Tom.
Microsoft Access MVP