I have a table with a "time" field in it which includes the ":" characters (hh:mm:ss) format. If I link this field to a text box control with the controlsource property the time shows up correctly in the text box. However, the user has to reenter the ":" if they modify the field. I tried using the InputMask property with a "99:99:99" mask (format property = KR) but the ":" are not stored with the value entered by the user and old values are not displayed properly.

How can I set up a text box for time input (hh:mm:ss) so the user does not have to enter the ":" but will be compatible with my current database?