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