time format

[Pam]

I have set up an input mask to format the time as military
and the problem I'm having, I would like to show 0300 as
0300, but when I type this in on my form and table it
shows as 300. Can this be set up to show 0300, I'm lost.

Thanks,

 

[Gary Miller]

Pam,

In the design view of the table that holds your time field,
change the Format to be Short Time. You may want to also do
that for the format of the control on your form as well. One
problem with input masks, is depending on how they are
setup, the data may not actually be stored like you are
inputting it with the mask.
--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________