Don, Thanks for the suggestion but although the text field would display
the way I wanted, wouldn't the original time field still display?
Michael
Don Friedman wrote:
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] <mailto:[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] <mailto:[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
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
