You might use the ::H suffix to hide the field.

Sent from my iPhone
Don Friedman
ProfessionalRecords.Com LCC
413-784-1600
412-784-1615 FAX

On Oct 19, 2009, at 4:34 PM, Michael Iannantuoni <[email protected] > wrote:

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] > 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


_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf

Reply via email to