Time Format

  • Thread starter Thread starter Christine
  • Start date Start date
C

Christine

I am new to 2007, I have a Date/Time field set to short time. The users do
not want to put : when they enter the time. But I need it to read as Military
time.
 
Debug.Print Format(Now(),"HhNn")

The above will display the hours and seconds like so at 11:50 PM: 2350

Do you also need the date?

To input without the : you are going to need an input mask on that field.
One big mistake is to display the field with one format, but to have the
input mask look like another. Drives the users crazy when they try to update
a field.
 
Back
Top