Multiple Page Report with Different Orientations

[Rosemary]

In Access 2007, I need to create a report with different orientations. For
example, pages 1 and 2 print portrait, pages 3 and 4 landscape, pages 5 and 6
portrait, etc.

First, I set up different reports in the correct orientation. Then I added
these reports as subreports in a main report. The first problem I encountered
was that the main report has only one page orientation. I added page breaks
after each subreport but that caused a blank page between each page. I also
tried to use the DoCmd OpenReport followed by the printer.orientation command
and then DoCmd PrintOut with ranges. But, none of this is working. What am I
doing wrong?

I want to be able to press a button from a form to preview all pages of the
report (in the correct orientation), and then print the report.

How do I:
1. Set up the report(s)
2. Preview/print the report with the correct orientations

Thank you so much for your help!

 

[John Spencer]

You cannot do this in Access. You are limited to one orientation in a
report.



'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================