Michael - offhand I'd say that the most obvious way is to use a computed text field programmed to duplicate the time field unless it reads 00:00 in which case it is empty or reads N/A or something like that.
Good luck. Don Friedman Pittsburgh On Sun, Oct 18, 2009 at 7:57 AM, Michael Iannantuoni < [email protected]> wrote: > I have a database which includes a Time filed formatted as T99:99 so > that 24 hour clock times display correctly with leading and trailing > zeros eg 09:30, however some records do not have time data so the field > displays 00:00. This can be misleading; is there a way to display time > fields so that entered data displays, even 00:00, but if nothing is > entered then the field does not display or displays as blanks? > > Michael > > _______________________________________________ > Dataperf mailing list > [email protected] > http://lists.dataperfect.nl/mailman/listinfo/dataperf > -- Don Friedman ProfessionalRecords.Com LLC PRS Data Systems 205 S Main Street Pittsburgh, PA 15215 412-784-1600 - 1-800-PRS-FILE 412-784-1615 Fax
_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
