Time help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
oxicottin said:
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!!!
Click to expand...

input masks only control how you enter stuff, not the data itself (at least with
date/times).

In a DateTime field zero = midnight on Dec 30, 1899. By default Access will
display only the time when the date is Dec 30, 1899 and will display only the
date when the time is midnight. That doesn't mean that those values aren't
still there. If a format forces the display of midnight then it will show up as
either 24:00:00 or 12:00:00 AM.
 
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
 
Back
Top