Microsoft Access Sub-Reports Orientation based on Actual sub-report setting

[Mohsin Malik]

Hi there,

I have Microsoft Access Main report that has 3 sub reports on the main report, 2 reports orientation are setup as portrait and 1 report orientation as landscape, I would like the same setting for the report but it keep the main report setting and print all report as portrait and there are columns in landscape sub report that are cut down due to this behaviour. I also want to print the same as one single PDF, can anyone advise if there is a way to accomplish this and keep the sub-report page settings while previewing/printing the report or exporting it as PDF?

Thank you
Mohsin

 

[JHB]

Sorry, it is not possible to have, (or to change), two different page orientation in a MS-Access report. You can do it in Word but not in MS-Access.

 

[vbaInet]

Food for thought: you would normally use the report's PrtDevMode property to change the orientation in design view but I wonder if it's also possible to do so in any of the other views? If it is then you can look to achieve this setup using the Print or Format event.