Nicholson, Karen
cyx5 at cdc.gov
Wed Dec 1 05:33:26 CST 2004
If the [txtnotes] are null, then would they not be not visible by definition of null? Set the field to allow it to shrink and the section of the report containing the field to allow shrinkage and then no code is needed (?) -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe Hecht Sent: Tuesday, November 30, 2004 6:46 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Which Report Event to use. and related code XP I want to set some code If is null [txtnotes] then [txtnotes].visible = false I am thinking that should go into the on format event, but I do not see that event. This text box is part of a sub report so it needs to check this for each row in the report. Thanks JOE HECHT LOS ANGELES CA jmhla at earthlink.net -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com