Hi all,
I have a field on a form tied to a date/time field in the database and the form needs a time (hr:mm). I am trying to speed up data entry by having the operator not have to type a colon in the time field. Is there a way for the operator to just type in a military time without the colon and have Access fill it in properly?
1430 = 2:30 PM
Thanks everyone.
PB
I have a field on a form tied to a date/time field in the database and the form needs a time (hr:mm). I am trying to speed up data entry by having the operator not have to type a colon in the time field. Is there a way for the operator to just type in a military time without the colon and have Access fill it in properly?
1430 = 2:30 PM
Thanks everyone.
PB
