HI, can anyone help me pls on how to set the paper size of my datareport on printing.
here is my code but it doesn't work. I don't know the reason why it does not work on me.

Printer.PaperSize = 5 'SET TO LEGAL PAPER SIZE
dr1.Orientation = rptOrientLandscape
dr1.Show

Help pls..

thanks...

Try and change the 5 to -

Printer.PaperSize = vbPRPSLegal

check this. it can help you more.

AndreRet: i have try your suggestion but still it doesn't work. still the size of the datareport is in letter paper size. Can you any more idea? i really need it badly.. thanks..

Thanks Guys for all your help. After a couple of days in searching to WWW finaly i found the answer.

It was a pleasure. How did you solve the problem?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.