Mike & Doris Manning
mikedorism at adelphia.net
Wed Dec 17 13:21:32 CST 2003
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