Forcing a new page

[OldManEd]

I have a report with following:

Report Header
Page Header
Group 1 Header
Group 2 Header
Detail
Group 2 Footer
Group 1 Footer
Page Footer
Report Footer

I want to force a new page every time the Group 1 header changes to a new
value.

I know how to do this in Access 2003 (XP) but can't find how to do it in
Access 2007 and Vista Home Premium.

Thanks for help

Ed

 

[Marshall Barton]

I have a report with following:

Report Header
Page Header
Group 1 Header
Group 2 Header
Detail
Group 2 Footer
Group 1 Footer
Page Footer
Report Footer

I want to force a new page every time the Group 1 header changes to a new
value.

I know how to do this in Access 2003 (XP) but can't find how to do it in
Access 2007 and Vista Home Premium.

Are you saying that setting Group 1 Header's ForceNewPage
property tp Before Section doesn't work in A2007?

 

[OldManEd]

Thanks for reminding me this was on properties; I thought it was in Grouping
& Sorting. However, tried every option (including using the Group 1 footer)
and nothing forces a new page. Is there another way.

 

[OldManEd]

I now see a new page when using Print Preview. However, when switching
between design view and report view all the records run together without any
sign of a page break. Is this a new feature of Access 2007??? I always
thought view and print preview were interchangable.

Ed

Thanks for reminding me this was on properties; I thought it was in
Grouping & Sorting. However, tried every option (including using the Group
1 footer) and nothing forces a new page. Is there another way.

 

[Allen Browne]

Ed, I just posted to your later question a comment about the difference
between Print Preview (events fire) and Report view or Layout view where the
events do not fire.