Cliff67
Registered User.
- Local time
- Yesterday, 20:00
- Joined
- Oct 16, 2018
- Messages
- 175
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
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