Time in a form not displaying correctly

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

Hello everyone. I'm hoping someone here can help me. I am
learning VBA on the fly and I know the basics of it, so if
the question seems dumb, I aplolgize.

I have a form that users input product data directly from
our line. They do a series of tests and input the results
in the Access form. One of the fields is called Time (I
set the field to Date/Time with the format set to Meduim
Time when I created the table). Since the users input the
time the test was done, I cannot use the Now() function.

For example, a user does a check at 11:45pm, when the user
types in 11:45 in the Time field, the form returns
11:45am, not PM.

Is there a simple setting for this, or is there code that
needs to be used?
 
Eric said:
Hello everyone. I'm hoping someone here can help me. I am
learning VBA on the fly and I know the basics of it, so if
the question seems dumb, I aplolgize.

I have a form that users input product data directly from
our line. They do a series of tests and input the results
in the Access form. One of the fields is called Time (I
set the field to Date/Time with the format set to Meduim
Time when I created the table). Since the users input the
time the test was done, I cannot use the Now() function.

For example, a user does a check at 11:45pm, when the user
types in 11:45 in the Time field, the form returns
11:45am, not PM.

Is there a simple setting for this, or is there code that
needs to be used?
Click to expand...

When entering time only the user must either supply the "am/pm" or use 24
hour format.
 
Back
Top