[AccessD] Report ForceNewPage Property

Carolyn Johnson cjlabs at worldnet.att.net
Thu May 14 12:39:25 CDT 2009


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


More information about the AccessD mailing list