Custom time formatting

[Guest]

I'm not sure if this question belongs here or in table design but...

I have a field in a table with data type as Date/Time, short time. When the
user enters 01:02 it displays as 1:02 which is OK but if the user enters a
time of 00:02 it displays as 2 with no leading zeros. How can I get it to
display all zero's so it would display 00:02?

Thanks

 

[Allan Murphy]

Set your input mask to 00:00;0;#

I entered 00:06 and it displayed 0:06

 

[Guest]

Thank you very much..

Set your input mask to 00:00;0;#

I entered 00:06 and it displayed 0:06