This seems like it should be an easy thing, yet it's driving me crazy.

When I type in the time (ie: it is an actual time elapsed that i'm entering), it end up getting AM PM.

How can I get this so that I enter in 1:24:24 to mean that the amount of time something took was 1 hour, 24 minutes, 24 seconds?

I've tried and succeeded in formatting it in a query, but i cannot alter the value when it is used as the datasource for a form.

Any thoughts on this?

You mentioning entering duration into a control. Is that control's underlying bound field an Access date/time field?

If so, be aware that Access date/time data type holds TIME OF DAY/DATE, not duration.

It is. What would be the best way to accomplish this so that I can measure duration appropriately?

A common approach to entering/using duration is to use a textbox. Since you are using numbers and expecting to do math, the underlying field needs one of the number-type data types defined.

Usually, you'd use the lowest unit of measure (i.e., if you need hours, minutes and seconds, store the number of seconds).

Then you'd need to use a small procedure to format the number (and/or the sum of those durations) in your preferred (?hh:mm:ss?) format. Check on-line, possibly at mvps.org/access for examples.

Hi Jeff-

I ended up creating 3 separate text boxes and labelling them hours, minutes and seconds to help me achieve what i wanted. I believe it might be a long way around the problem, but it is currently working... in my mind, it's a KISS solution.