Max Wanadoo
max.wanadoo at gmail.com
Thu May 14 10:22:06 CDT 2009
Got it! Here is an example of where it is used: Private Sub GroupHeader4_Print(Cancel As Integer, PrintCount As Integer) Reports![Transactions RQI_RODailyIncomeDetailed].Section("GroupHeader4").ForceNewPage = 3 End Sub Note that the SECTION has been indexed by inserting the sub group header name in quotes. Thanks Lambert 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 >