Subreport Different page orientation

  • Thread starter Campbell via AccessMonster.com
  • Start date
C

Campbell via AccessMonster.com

Hi all and TIA,

I've got 2 reports. The main report is in potrait orientation and will be
printed for each record in the query used to generate the report.

Some of these reports will require a second report to be run. I want to keep
the 2 reports together in the generation so that the user can print off the
items and have them properly collated.

The kicker is that the 2nd report is in landscape orientation. When I try to
add a sub-report that is displayed or hidden based on a value in the main
report, the entire report opens wider and then will print off blank pages
because of the extra page size.

Is it possible to do this as a sub-report? Or if not, is there another way
of approaching the issue that will still allow both reports to print off
together.
 
C

Campbell C via AccessMonster.com

So this isn't possible using strictly the access report designer. What about
VBA?
 
Top