Landscape and Portrait in the same report?

[Zwoker]

Hi all,

In MS Access 2003 I'm trying to produce a report that has the some sections (the header section for the first sort item) in Landscape, and the rest in Portrait.

I tried using code like Me.Printer.Orie ntation = "n" (where n is 2 for portrait and 1 for landscape), but found that it seems whatever the last "format change" code executed by the report is what I get for the whole report, not just the section_format code it was in.

Does anyone know if it is possible to do this, and if so, do you have some example code?


Thanks,
Zwoker.

[Stewart Ross]

As the page settings apply to the whole report it is not possible for Access reports to use both portrait and landscape orientation in different sections. Word can do this, by use of separately-formatted sections within the same Word document, but not Access.

It would be possible to simulate the approach you want - header oriented one way, body of report another - by using two reports in sequence.

-Stewart

[youmike]

Sub-reports might be another solution - probably not in this situation. I'd attend to the need by a VBA script to print a succession of reports, setting the page number in successive reports, if necessary.

[NeoPa]

Good thinking, but in this case I'm fairly sure that any sub-report would be constrained by the orientation of the main report.

This leaves us basically, with something that boils down to the same as Stewart's solution - Multiple reports - possibly automated to print together as one.

This would be my approach too :)