Custom time formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Back
Top