Solved

Report Layout:  One Record Per A4 Page

Posted on 2011-03-24
2
385 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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)

Question has a verified solution.

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

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

752 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