time format - enter without a colon

S

Sarah

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
 
M

Mr B

Sarah,

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

HTH
Mr. B
 
S

Sarah

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
 
M

Mr B

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
 
Top