Mitsules, Mark S. (Newport News)
Mark.Mitsules at ngc.com
Wed Dec 17 13:49:16 CST 2003
To clarify, here is my report shown in Example 1. Given "x" number of records, the group footer may be pushed to the next page in the report as shown in Example 2. Mark Example 1: **************** * Page Header * **************** * Group Header * **************** * Detail 1 * * Detail 2 * * Detail 3 * * Detail... * **************** * Group Footer * **************** * Page Footer * **************** Example 2: Page 1 Page 2 **************** **************** * Page Header * * Page Header * **************** **************** * Group Header * * Group Footer * **************** **************** * Detail 1 * * Page Footer * * Detail 2 * **************** * Detail 3 * * Detail... * **************** * Page Footer * **************** -----Original Message----- From: Mike & Doris Manning [mailto:mikedorism at adelphia.net] Sent: Wednesday, December 17, 2003 2:22 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Access Reports: On Print Event / On Format Event The OnFormat event occurs before the section is formatted. The OnPrint event occurs before the section is printed. The only way I can think of to accomplish your first task is to use a variable to track whether or not the detail section printed and check this in the OnPrint event of the page footer. The second part has me totally baffled because if there is no detail then there shouldn't be a group footer. Doris Manning Database Administrator Hargrove Inc. www.hargroveinc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mitsules, Mark S. (Newport News) Sent: Wednesday, December 17, 2003 1:10 PM To: '[AccessD]' Subject: [AccessD] Access Reports: On Print Event / On Format Event I am not familiar with the "On Print" event capabilities: While printing a report, in the case where a report page does not contain any detail records (only a group footer and page footer), how can I set a single control (in the page footer) to NOT print its contents? Then, secondly: Is there a way to identify these situations beforehand (I'm guessing the On Format event) and print ONLY those pages? Mark _______________________________________________ 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