Report Aspect ratio

[Cliff67]

Hello everyone

Don't you just love it when someone finds something new to do with a standard report you make?

Anyway my boss now wants a previously print or preview report to be displayed on a screen in the Engineering office. Not a problem I think, just export to PDF, which works a treat, however, person who loads stuff onto these screens needs the PDF in a 16/9 aspect ratio.

I usually place the code below in the On Open part of the report so I can force the orientation and paper size to fit the printers in the UK.

Printer.Orientation = acPRORLandscape
Printer.PaperSize = acPRPSA4

Any ideas how I now set the ratio or set it to 1080(HD output)?

Thanks in advance

Cliff

 

[theDBguy]

Hi Cliff. Not sure what the dimensions for an A4 paper are, but for an 11x8.5 paper, to get a 16:9 aspect ratio, I think you'll have to change the paper size to 11x5.84375