Heenan, Lambert
Lambert.Heenan at aiuholdings.com
Thu May 14 09:41:38 CDT 2009
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