Access Reports - Inserting Tables on 11x 17 sheets

I have an access report that prints portrait pages 8 ½” x 11”

I would like to include some fold-out landscape pages 11” x 17” at certain points throughout the report

Can anybody help with this?
rogerdjrAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
AFAIK, you cannot change page sizes in the same report. You'd have to build separate reports, and build an external routine to print out the report in the manner you desire. For example, you could gather your data in temporary tables, determine what data would be presented on your 8.5 x 11 and print that, then determine what data would be printed on your 11 x 17 and print that, and so forth.

Or you could do this with a more robust reporting engine, like Crystal Reports.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.