Time help

[oxicottin]

Hello I have a text box on my form and I want to be able to enter short time
into it. I enter 00:00;;_ in the input mask and when I look at my form in
regular view it showes 12:00:00AM I had also tried 00:00;0;_ and it worked it
showed 0:00 in my text box in normal view but recorded 12:00:00AM in my table
when I didnt evern enter data. what am I doing wrong? Thanks!!!

Reguards,
Chad

 

[tina]

first, you need to be sure the field in the *table* has a data type of
Date/Time. the date/time value in Access is actually a Double, where the
values to the left of the decimal are a date, and the values to the right of
the decimal are a time.

so the time value you see (in a table view, query view, form view, report
view) is simply a matter of *formatting*, since the stored time value is
always a fraction of a whole number. to change what you see in your form,
change the Format property of the textbox control in the form. suggest you
read up on the Format property in Access Help so you'll know how to set it
to suit your needs.

hth