Creating a two page report in Access

I would like to create a two page report in MS-Access with the second page being printed on the reverse side of the page (i know this also has to do with the printer settings, i.e., duplex printing). Where and how do I create the second page of the report?
geeta_m9Asked:
Who is Participating?
 
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
<My printer is configured for duplex, however, I do not know where the first page ends and the second page begins in the report. >

Open the report in "Print Preview" explicitly and you will see actually where the page breaks.

The Default view for reports in Access 2007 and newer is "Report  View"
This view does not display the page breaks.

If you open the Report in Print Preview, explicitly, you will see the breaks.

JeffCoachman
0
 
Jeffrey CoachmanMIS LiasonCommented:
In the most basic sense, this is controlled by the Printer.
If your printer is configured as "Full Duplex", then if your data spans two pages, second page will be on the reverse side of Page 1

Are you saying that your printer is configured for full duplex (double sided Printing)... and it is NOT printing on both sides of the paper?
0
 
geeta_m9Author Commented:
My printer is configured for duplex, however, I do not know where the first page ends and the second page begins in the report.
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
Check your Printer settings for the Report:

Open the report in Design View
(Make a small change to the design of the report ...ex: Move a control slightly)
Click the "Page setup" tab
Click the "Page setup" Icon
Click the "page" Tab
Select: "Use Specific Printer"
Select your Printer
Select Properties, ...and make sure "full Duplex" or "double Sided" printing is selected.
Save the Report.
Close the Report.
Compact and repair the database.
Try printing the report again.

JeffCoachman
0
 
geeta_m9Author Commented:
So, would I have to do it by trial and error to determine where the new page starts. Doesn't Access have a way of delineating the pages?
0
 
geeta_m9Author Commented:
Ok, your last response crossed with my latest comment. Let me try what you suggested.
0
 
geeta_m9Author Commented:
Thanks!
0
 
Jeffrey CoachmanMIS LiasonCommented:
;-)
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.