Solved

Report Layout:  One Record Per A4 Page

Posted on 2011-03-24
2
346 Views
Last Modified: 2012-05-11
Hi,

I am designing an Access Report.
Actually, it is more like an "Invoice" or "Order Confirmation".

Consequently, I only want ONE record per page.
How do I achieve this?
Is it to do with "Grouping"  (Each customer has a unique code).

0
Comment
Question by:Patrick O'Dea
2 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 500 total points
ID: 35205533
Probably, but it does depend on what your page looks like.

The page throw is controlled by a property setting of each section header bar.
In a grouped report, with each group starting on a new page, you would probably use the group footer section bar - right-click and choose properties and then find the 'Force New Page' property and set it to After Section.



0
 

Author Closing Comment

by:Patrick O'Dea
ID: 35205541
Thanks Peter , It was the "Force Page" ...
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

708 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

11 Experts available now in Live!

Get 1:1 Help Now