Is there a way to have two sub forms on one report, and have their own orientation ? I have found in a few posting where this was not allowed with previoseu versions of MA, but what about 2007 on ?
-
-
I believe this can be done but never have. I have seen an example of a monthly report that had a Front Cover sheet then various sections inside. It may have been in Northwind or some tools that shipped with Access.
I guess you would have to put a PageBreak just before the sub-report. Then to change the orientation you would put some code in the On_Open, or On_Format, or On_Print event. Something like;-I don't know this works but is something to try!!Code:Me.Printer.Orientation = acPRORLandscape
S7
Comment