[AccessD] Report ForceNewPage Property

Or you can do it in the format event of the section where you want to force a new page so that is changes dynamically as the report is formatted (you never know, someone might want that)...

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    If Me.Resolution = "Whatever" Then
        Me.Section(acDetail).ForceNewPage = 1
    Else
        Me.Section(acDetail).ForceNewPage = 0
    End If
End Sub


-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Carolyn Johnson
Sent: Thursday, May 14, 2009 1:39 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Report ForceNewPage Property

I set the ForceNewPage property in the report open sub.

    If blnSeparatePageByCategory = True Then
        GroupFooter1.ForceNewPage = 2
        GroupFooter0.ForceNewPage = 0
    Else
        GroupFooter1.ForceNewPage = 0
        GroupFooter0.ForceNewPage = 2
    End If



HTH,
Carolyn Johnson

  ----- Original Message -----
  From: Max Wanadoo
  To: Access Developers discussion and problem solving
  Sent: Thursday, May 14, 2009 9:49 AM
  Subject: Re: [AccessD] Report ForceNewPage Property


  Hi Lambert,
  I dont want to retrieve the current value, I want to set it.  The OLH only
  give what you have quoted, it doesn't give an example of how to use it to
  change the value.  I have tried it in all the sections but to no avail.
  Max


  On 5/14/09, Heenan, Lambert <Lambert.Heenan at aiuholdings.com> wrote:
  >
  > Max,
  >
  > ForceNewPage is a method of a report *Section*, not of the report itself.
  > The OL-Help gives this example of how to use it...
  >
  >
  > Dim intGetVal As Integer
  > intGetVal = Reports![Sales By Year].Section(acDetail).ForceNewPage
  >
  >
  > HTH
  >
  > Lambert
  >
  >
  > -----Original Message-----
  > From: accessd-bounces at databaseadvisors.com [mailto:
  > accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
  > Sent: Thursday, May 14, 2009 9:53 AM
  > To: Access Developers discussion and problem solving
  > Subject: [AccessD] Report ForceNewPage Property
  >
  > Can anybody tell me how to code the
  >
  > ForceNewPage Property on a Report?
  >
  > It won't take me.ForceNewPage or Report.ForceNewPage and it won't take it
  > by itself.
  >
  > I want to try ForceNewPage = 1 and ForceNewPage = 2 and ForceNewPage = 3 to
  > see the effects on my report for each one.
  >
  > The help does not give an example.
  >
  > Thanks
  >
  > Max
  >
  > --
  > AccessD mailing list
  > AccessD at databaseadvisors.com
  > http://databaseadvisors.com/mailman/listinfo/accessd
  > Website: http://www.databaseadvisors.com
  >
  >
  > --
  > AccessD mailing list
  > AccessD at databaseadvisors.com
  > http://databaseadvisors.com/mailman/listinfo/accessd
  > Website: http://www.databaseadvisors.com
  >
  --
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com