Member Avatar for xirosen

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...

  • 3 Contributors
  • 5 Replies
  • 239 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by AndreRet
Member Avatar for AndreRet

Try and change the 5 to -

Printer.PaperSize = vbPRPSLegal
Member Avatar for abu taher

check this. it can help you more.

paper_size.zip (138.47 KB)
Member Avatar for xirosen

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..

Member Avatar for xirosen

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

Member Avatar for AndreRet

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.