Short time format problem in Access 2007

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!

post the format settings you've tried, please.


"Lloyd" wrote in message
...
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!

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

"tina" wrote:

post the format settings you've tried, please.


"Lloyd" wrote in message
...
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!

On Sun, 23 Nov 2008 09:01:00 -0800, Lloyd wrote:

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

"tina" wrote:

post the format settings you've tried, please.


"Lloyd" wrote in message
...
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?

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.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com