define paper Size when do printing

[marnkei]

hai, i wish somebody can help in define the paper size while i'm doing the printing....

i know that we can define the paper format or even customize our paper size at the printer properties but what i want is using coding to fix the paper size rather than let user to change the paper size or reselet the paper format...

can anybody help me to solve this problem...
thank ...i nee in ASAP.....

sky

[Nrapendra Singh]

r u using form or any thing else for printing ??

[MerrionComputin]

Not all printers/printer drivers support custom paper sizes, but those that do can be set thus:

Printer.PaperSize = vbPRPSUser
Printer.Width = 1500
Printer.Height = 1500

HTH,
Duncan