Short time format problem in Access 2007

[Lloyd]

In my table, I have a date/time field and have format the field for short time.

When I enter 00:34 hours, the table converts that to 0:34 hours dropping the
first zero. I have tried various ways to format the field but can not get
access 2007 to properly format the field in a 24 hour format.

When my form is displayed, it displays it in the same way as its stored in
the table 0:34.

Is there a way to get the table to store the data correctly in a 24 hour
military format style? If not, how about a way to get it to display
correctly in the form the end user will see?

Thanks!

 

[tina]

post the format settings you've tried, please.

 

[Lloyd]

The only format option I am aware of is "short time". I tried hh:nn but that
converts to short time when you tab out of the format field.

I dont know of any other options I have.

thanks

 

[Rick Brandt]

The only format option I am aware of is "short time". I tried hh:nn but
that converts to short time when you tab out of the format field.

I dont know of any other options I have.

thanks

I have never been able to get leading zeros on hours with a format
property. You would need to use an expression that returns a string to
build up the format you want.