Time Format

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.
 
J

Jerry Whittle

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top