input for a time field using military time? 2

[striker73]

Is there a way to set the input for a text box so that if a user enters 14.5, the textbox will display 2:30 PM?

 

[StillLearning]

A quick solution is to open the table that contains the time field in Design view. Change the field type to date/time and specify the field properties to "Medium time". This should give you the desired results.

 

[evalesthy]

You can put an input mask in the field on the form as 00:00;0;_ and then put an input mask on the field in the table as 09:00\>LL;0;_ and it should do what you want.