time format - enter without a colon

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a time field with a date/time data type and a medium time format. I
would like to be able to type the time without inputting a colon (700pm). I
would appreciate any guidance on how to do this.

I have been able to solve many of my access questions with information found
on this discussion group. It is a wonderful resouce.

Sarah
 
Sarah,

Try the Input Mask property. Set it to ShortDate just as you did the Format.

HTH
Mr. B
 
Thanks for responding so quickly. Your suggestion did work, however, you
still have to type 0700 with short and 0700p with medium. I seen time fields
work where you type 700, it auto adds the other 0 and auto enters the am or
pm (it must look at the current time to determine that). Any suggestions on
how to make the field work this way?

Thanks for your help.

Sarah
 
Sarah,

Try using the following iin the input mask: 00:00;0;_

You will have to enter you time in 24 hour time.
For example if you enter: 1725 it will appear as 5:25 PM, without having to
enter the colon.

Mr. B
 
Back
Top