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

On Mon, 7 Jun 2010 23:25:11 -0700 (PDT), Daniel
<(E-Mail Removed)> wrote:

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

-Tom.
Microsoft Access MVP


>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

On Jun 9, 12:38*pm, Tom van Stiphout <tom7744.no.s...@cox.net> wrote:
> On Mon, 7 Jun 2010 23:25:11 -0700 (PDT), Daniel
>
> <daniel.ran...@gmail.com> wrote:
>
> Check out the Printer object; it has a PaperSize property.
>
> -Tom.
> Microsoft Access MVP
>
>
>
> >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- Hide quoted text -
>
> - 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

On Tue, 8 Jun 2010 22:13:59 -0700 (PDT), Daniel
<(E-Mail Removed)> wrote:

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

-Tom.
Microsoft Access MVP


>On Jun 9, 12:38*pm, Tom van Stiphout <tom7744.no.s...@cox.net> wrote:
>> On Mon, 7 Jun 2010 23:25:11 -0700 (PDT), Daniel
>>
>> <daniel.ran...@gmail.com> wrote:
>>
>> Check out the Printer object; it has a PaperSize property.
>>
>> -Tom.
>> Microsoft Access MVP
>>
>>
>>
>> >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- Hide quoted text -
>>
>> - 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