Can Access 2000 Time Value Be dispalyed pass 23:59PM

B

Brownnate

I want to know if anyone know how to get Access 2000 Date/Time property to
display 24:00 hours and more in a text field on a form.
 
J

Jeff Boyce

Brownnate

I may not be understanding your description, but it sounds like you are
trying to use an Access Date/Time field to hold a duration ("24:00 hours and
more").

Date/Time data time is designed to hold "point-in-time" information. As far
as I know, there is NOT an Access data type to hold duration data.

Or have I misunderstood...?
 
A

Arvin Meyer

Actually, you can use a Double to hold the information if you need to
calculate it, but you cannot display it that format without converting it to
text with a custom function. (Then it can no longer be calculated.)
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Top