Page break problem

  • Thread starter Thread starter dinadvani via AccessMonster.com
  • Start date Start date
D

dinadvani via AccessMonster.com

Hi,

I have a report which gives the below output:

Account : ABC co.

Sr. No. Amount
1 500
2 450
5 50
6 25
Total 1025

So on and so forth for many accounts. Now the problem is if a page comes to
an end half the data for 1 account is printed on 1st page and second half on
next page.

Is it possible to do something so that if a data cannot be fitted on that
page it gets printed on next page. I know I am asking too much, but I am new
to access.

Please Help
 
Use the report's Sorting and Grouping feature (View > Sorting and Grouping,
or use the toolbar icon). In the Sorting and Grouping dialog, select the
company field, and set the Group header to Yes. It probably makes sense to
put the company name into the group header, but even if you leave it blank I
believe the header needs some height, even if it's .01. Right click a blank
area in the group header, and select Properties. Set Force New Page (on the
Format tab) to Before Section. You could use the same technique to add a
group footer instead, except you would probably want to force a new page
after the section.
 
In report's Sorting and Grouping dialog (View: Sorting and Grouping)
-- Group on Account field
-- Set Keep Together to Whole Group.
 
Back
Top