Short Time but not

  • Thread starter Thread starter SAC
  • Start date Start date
S

SAC

I have a field that I have formated in the table with short time.

A control on a form is bound to this field and the control is also formateed
to shor time. However when I click on the control I see the date and the
time. How can I make it so I only see the short time when I click on the
control?

Thanks.
 
I conducted an experiment. I changed a time field to short time. Then I
added Now() in the default value field. When I clicked inside it showed me
the date and time. I deleted Now() and the field continues to show the date
with the time. In my other time field I just changed the format to short
time and entered time() in the default value section. When I click inside
the time I see 6:55:00 PM format.

I think these results are by design. Time will always contain hours,
minutes, and seconds for calculation purpose. You are only using that info
to 'show' the data as military time.
 
Thanks.

GVaught said:
I conducted an experiment. I changed a time field to short time. Then I
added Now() in the default value field. When I clicked inside it showed me
the date and time. I deleted Now() and the field continues to show the date
with the time. In my other time field I just changed the format to short
time and entered time() in the default value section. When I click inside
the time I see 6:55:00 PM format.

I think these results are by design. Time will always contain hours,
minutes, and seconds for calculation purpose. You are only using that info
to 'show' the data as military time.
Click to expand...
 
Back
Top