time edit

[Sam]

I have a time field with format set to medium time. When the user wants to
edit the time, the date part of the field shows up and you have to cursor
over to the time. This is annoying. Is there any way to suppress this and
show only the time when edits are being made?

Thanks,
Sam

 

[Arvin Meyer MVP]

There is no such thing as a Time Field, or a Date Field. It is a Date/Time
datatype and both are present even if only 1 shows. You are storing a date
of 12/30/1899 even when you enter only the time.

Change the format in the table design view, and you should be able to
display a medium time only.