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 ?