Link to home
Start Free TrialLog in
Avatar of Paul McCabe
Paul McCabe

asked on

Short Time Formatting with a zero in front of single digits

MS Access 2013: I have a field in a table that displays short time (i.e. the time is formatted as hh:nn). 9:00am displays as "9:00", but I would like to get it to display as "09:00". Does anyone know how this can be achieved  ?
ASKER CERTIFIED SOLUTION
Avatar of Michael Fowler
Michael Fowler
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Paul McCabe
Paul McCabe

ASKER

Thank you for the suggestion and pointing me towards the link, which provided valuable information on solving this issue. I am using Windows 7, and the system was set to 24 hour time format (HH:mm), but the time in the task bar still displayed as "9:05". I eventually got it to display as "09:05" by changing the long time setting to HH:mm:ss. No idea why, but it works.  Once the system was displaying time in this format, Access  followed suit ! I know this is not the most robust solution, but the number of users is small, so it is not an issue to adjust system settings for all PCs. Thank you again for your help !