Solved

Access Reports - Inserting Tables on 11x 17 sheets

Posted on 2013-06-17
1
128 Views
Last Modified: 2013-07-01
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?
0
Comment
Question by:rogerdjr
1 Comment
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
Comment Utility
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

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now