Access short time - need leading zero
Posted on 2011-03-18
I have a time text box that needs to display the leading zero for short time (military time). I have tried "hh:nn" (which Access changes to "short time") but it still drops the leading zero. I have even tried to change my system setting for displaying short time (I'm using Windows 7) but nothing I do seems to display the leading zero. ("Short time" actually displays without the leading zero in other applications such as Excel, although in Excel, I can successfully use "hh:mm"..) The problem is that the input mask requires a 2-digit hour, but when users sees a single-digit hour displayed, they don't enter 2-digits. One user tried to just change the second digit of the minutes, but got an error message (because the hour was a single-digit). This is a bound text box. Any suggestions will be welcomed.