Solved

Report Layout:  One Record Per A4 Page

Posted on 2011-03-24
2
359 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
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…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

911 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

19 Experts available now in Live!

Get 1:1 Help Now