[AccessD] Access Reports: On Print Event / On Format Event

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


More information about the AccessD mailing list