TIME display in date/time field: 24 hr clock?

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

Guest

In Access2002, I have a date/time in a textbox control. I want the time to
ALWAYS DISPLAY in 24 hour format. However, when the control loses focus, the
time immediately gets displayed as xx:yy AM/PM. General Date format doesn't
allow for a 24-hour clock-time display, which is what I need. (This
application is for our security services, and they live and die by the
24-hour clock.)

So please, what custom format can I create (the syntax please) to display
date/time as:

MM/DD/YY hh:mm

where the "hh" field is 0-23 and doesn't show AM/PM text?

thanks!!
 
Hi! i need help. i am working for a car park company. i want to enter the
time as h.mm in the excel but it should come out as h:mm format. i tried
changing the format cell and made it to that format but when i type the time
as ex 6.04 it comes out as a different number not that 6:04 that i want to
come out

KARL DEWEY said:
Format([YourDateField], "MM/DD/YY hh:mm")

--
KARL DEWEY
Build a little - Test a little


Dennis said:
In Access2002, I have a date/time in a textbox control. I want the time to
ALWAYS DISPLAY in 24 hour format. However, when the control loses focus, the
time immediately gets displayed as xx:yy AM/PM. General Date format doesn't
allow for a 24-hour clock-time display, which is what I need. (This
application is for our security services, and they live and die by the
24-hour clock.)

So please, what custom format can I create (the syntax please) to display
date/time as:

MM/DD/YY hh:mm

where the "hh" field is 0-23 and doesn't show AM/PM text?

thanks!!
Click to expand...
Click to expand...
 
suggest you post to an Excel newsgroup. this ng answers questions about
writing VBA code in MS Access relational database form objects.


michelle said:
Hi! i need help. i am working for a car park company. i want to enter the
time as h.mm in the excel but it should come out as h:mm format. i tried
changing the format cell and made it to that format but when i type the time
as ex 6.04 it comes out as a different number not that 6:04 that i want to
come out

KARL DEWEY said:
Format([YourDateField], "MM/DD/YY hh:mm")

--
KARL DEWEY
Build a little - Test a little


Dennis said:
In Access2002, I have a date/time in a textbox control. I want the time to
ALWAYS DISPLAY in 24 hour format. However, when the control loses focus, the
time immediately gets displayed as xx:yy AM/PM. General Date format doesn't
allow for a 24-hour clock-time display, which is what I need. (This
application is for our security services, and they live and die by the
24-hour clock.)

So please, what custom format can I create (the syntax please) to display
date/time as:

MM/DD/YY hh:mm

where the "hh" field is 0-23 and doesn't show AM/PM text?

thanks!!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top