If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
Short time format problem in Access 2007
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! |
#3
|
|||
|
|||
Short time format problem in Access 2007
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! |
#4
|
|||
|
|||
Short time format problem in Access 2007
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 |
Thread Tools | |
Display Modes | |
|
|