Page break

[Guest]

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.

 

[Guest]

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

 

[Marshall Barton]

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.

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).

 

[Guest]

Thanks a million - it works perfect

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

 

[Guest]

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

What other change sneeded to be made?

 

[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

*