>I have a time field in a form like 08:30:00 (8:30am). If no time is entered in the time field its status is EMPTY(). But if a time is entered in the time field its status is NOT EMPTY().
>
>But what if the user enters a time such as 08:30:00 and then decides to blank it out and makes it " : : ". Then the time field status is blank and passes as NOT EMPTY().
>
>How can I reset the time field from blank to empty so when I check the time field for EMPTY() the time field is truly empty and not blank?
>
>Thanks. This is probably an easy one. But the blanks are really messing up my logic and time calculations.

Do a STRTRAN(TimeField, ":", "") to remove the colons.

Steve