force new page

[Souris]

I would like to force a new page every group header, but I want to keep the
first group header with report header. I set group header force new page
before section. The only problem is the first page it only has report header.

Are there any way to force new page for every group header, but not the
first group with report header?


Your information is great appreciated,

 

[Golfinray]

Try to forcenewpage in the header properties. Right click on the header and
forcenewpage there.

 

[Souris]

Thanks for the message,
yes, I use the force page, but the first page is not on the report header
page.
The rest are fine.

Thanks again,

 

[John Spencer]

Could you use the group footer to force the new page instead of the group
header?

Another way would be to put a page break control in the group header at the
very top and then use code to make it visible / not visible.
In addition to the page break control, add a text control to the group
header and set it up as follows
Name: txtGroupCounter
Control Source: = 1
Running Sum: OverAll
Visible: No



In the Group Header's Format event you would need code something like

Private Sub GroupHeader1_Format(Cancel As Integer, FormatCount As Integer)
Me.NameOfPageBreakControl.Visible = Me.TxtGroupCounter > 1
End Sub


--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Souris]

Thanks millions,

Could you use the group footer to force the new page instead of the group
header?

Another way would be to put a page break control in the group header at the
very top and then use code to make it visible / not visible.
In addition to the page break control, add a text control to the group
header and set it up as follows
Name: txtGroupCounter
Control Source: = 1
Running Sum: OverAll
Visible: No



In the Group Header's Format event you would need code something like

Private Sub GroupHeader1_Format(Cancel As Integer, FormatCount As Integer)
Me.NameOfPageBreakControl.Visible = Me.TxtGroupCounter > 1
End Sub


--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[John Spencer]

Out of curiousity - which solution did you use?

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..