Force new page

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Phil - 09 Oct 2004 15:25 GMT

HI,

I have a form with a command button that previews a report
with a group on teachers and a group heading
called "GroupHeader2".

I want to place a check box on the form called "ckNewPage"
which if checked will cause the report to force a new page
for each teacher. What code would I use and where would
it go? I've tried many things but no success....

Thanks,
Phil

Reply to this Message

Allen Browne - 09 Oct 2004 16:08 GMT

Use the Open event of the report to read the check box (if the form is
open), and set the ForceNewPage property of the group header:

Private Sub Report_Open(Cancel As Integer)
Const conNewPageBefore As Byte = 1

If CurrentProject.AllForms("NameOfYourFormHere").IsLoaded Then
If (Forms("NameOfYourFormHere")!chNewPage.Value) Then
Me.Section(acGroupLevel1Header).ForceNewPage = conNewPageBefore
End If
End If
End Sub

Note: Access 97 and earlier do not have the AllForms collection. For those
versions, copy the IsLoaded() function from the Northwind sample database,
and use that instead.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> I have a form with a command button that previews a report
> with a group on teachers and a group heading
[quoted text clipped - 7 lines]
> Thanks,
> Phil

Reply to this Message