Page break

M

Mr. G

I want the report to do a page break when the value in a filed changes:
my report looks like this:

Bld:
Apt:
Name:
rentAmount:

I want make a report for each building, I tried grouping the filed 'Bld' and
setting the 'forceNewPage after selection' but what it does it does a break
after each record.
 
O

Ofer

Create a Group for the Bld field, Go to view, sorting and grouping, select
the bld field, and then select the GroupFooter Property for this field to
true, now a new section apear in your report, in this section add a page
break.
That will force a new page after each building
 
M

Marshall Barton

Mr. G said:
I want the report to do a page break when the value in a filed changes:
my report looks like this:

Bld:
Apt:
Name:
rentAmount:

I want make a report for each building, I tried grouping the filed 'Bld' and
setting the 'forceNewPage after selection' but what it does it does a break
after each record.
Click to expand...


It sounds like you used ForceNewPage on the detail section.
You need to use the ForceNewPage property on the group
header (Before Section) or the group footer (After Section).
 
M

Mr. G

Thanks a million - it works perfect

Ofer said:
Create a Group for the Bld field, Go to view, sorting and grouping, select
the bld field, and then select the GroupFooter Property for this field to
true, now a new section apear in your report, in this section add a page
break.
That will force a new page after each building
Click to expand...
 
A

aMack

Used his tool - however it inserts a blank page between the Groups.

What other change sneeded to be made?
 
S

strive4peace

check the width of your report -- perhaps it is wider than
the page can display

also, try Page Break BEFORE in the group header section
instead of doing a break after


Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day ;)

remote programming and training
strive4peace2006 at yahoo.com

*
 
Top