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
|
|||
|
|||
Time Format - Need all 4 digits shown
Hi,
I have an operations database that tracks our tug boat voyages and use the standard 24 hour timeclock. The times are shown with the short time format, but I need all 4 digits to show. In the maritime world, time is always shown in 4 digits. In Excel you can do it by setting the format to [hh]:mm Supposedly, if Excel can do it, Access can too. So how does it? Thanks, Captain Scott Carter Sause Brothers Inc Honolulu Hawaii |
#2
|
|||
|
|||
Time Format - Need all 4 digits shown
You can do this in Access by setting the Format property for the control or
by using the Format function, depending on what you're trying to do. Another option, if you want everything this way, would be to go to Regional Settings in Control Panel and change the description of Short Date to give you all four digits. Example Format property for a control: hh:mm -- Wayne Morgan Microsoft Access MVP "scott" wrote in message ... Hi, I have an operations database that tracks our tug boat voyages and use the standard 24 hour timeclock. The times are shown with the short time format, but I need all 4 digits to show. In the maritime world, time is always shown in 4 digits. In Excel you can do it by setting the format to [hh]:mm Supposedly, if Excel can do it, Access can too. So how does it? Thanks, Captain Scott Carter Sause Brothers Inc Honolulu Hawaii |
#3
|
|||
|
|||
Time Format - Need all 4 digits shown
Example Format property for a control: hh:mm I think Wayne meant to say hh:nn - n is miNutes, m is Months! John W. Vinson |
#4
|
|||
|
|||
Time Format - Need all 4 digits shown
If they wouldn't put the n and m so close together on the keyboard.... Oh
well. :-) Thanks, John. -- Wayne Morgan Microsoft Access MVP "John Vinson" wrote in message ... Example Format property for a control: hh:mm I think Wayne meant to say hh:nn - n is miNutes, m is Months! John W. Vinson |
#5
|
|||
|
|||
Time Format - Need all 4 digits shown
Alphabetically, minutes comes before months so long ago Bill should have
assigned "m" to minutes. And since "m" was already taken when he came to month, Bill should have assigned "n" to month. So you see, you were logically right with hh:mm; Bill was in error! Perhaps Bill was using reverse polish notation when he assigned "m" and "n". Steve PC Datasheet "Wayne Morgan" wrote in message ... If they wouldn't put the n and m so close together on the keyboard.... Oh well. :-) Thanks, John. -- Wayne Morgan Microsoft Access MVP "John Vinson" wrote in message ... Example Format property for a control: hh:mm I think Wayne meant to say hh:nn - n is miNutes, m is Months! John W. Vinson |
#6
|
|||
|
|||
Time Format - Need all 4 digits shown
For the life of me I believe that this is what I already tried...But I will
check it tmro when I get back to work. I couldn't find the details of the format code [hh]:nn in help. Is that what forces the leading zero? I suppose its possible that it can show with the leading zero in a query, but not come thru in the report with the same data? I'll try to go back to the entry level data (the table where it is initally placed) and check the properties for that control. Thanks for the quick replies, Scott "Wayne Morgan" wrote in message ... You can do this in Access by setting the Format property for the control or by using the Format function, depending on what you're trying to do. Another option, if you want everything this way, would be to go to Regional Settings in Control Panel and change the description of Short Date to give you all four digits. Example Format property for a control: hh:mm -- Wayne Morgan Microsoft Access MVP "scott" wrote in message ... Hi, I have an operations database that tracks our tug boat voyages and use the standard 24 hour timeclock. The times are shown with the short time format, but I need all 4 digits to show. In the maritime world, time is always shown in 4 digits. In Excel you can do it by setting the format to [hh]:mm Supposedly, if Excel can do it, Access can too. So how does it? Thanks, Captain Scott Carter Sause Brothers Inc Honolulu Hawaii |
#7
|
|||
|
|||
Time Format - Need all 4 digits shown
Scott, Yes that [hh] is what forces the leading zero. Lookup Format in help
and click the Format Property then select the Date/Time Data Type link. Scroll down and there's a list of the different formats. Keep in mind that if you change the format at the table level you will still have to either add the format to the controls on the forms/reports because it will not automatically be set. The other thing you could do is delete the control and re-add it to the form/report and your new format will be set for you. -- Reggie ---------- "scott" wrote in message ... For the life of me I believe that this is what I already tried...But I will check it tmro when I get back to work. I couldn't find the details of the format code [hh]:nn in help. Is that what forces the leading zero? I suppose its possible that it can show with the leading zero in a query, but not come thru in the report with the same data? I'll try to go back to the entry level data (the table where it is initally placed) and check the properties for that control. Thanks for the quick replies, Scott "Wayne Morgan" wrote in message ... You can do this in Access by setting the Format property for the control or by using the Format function, depending on what you're trying to do. Another option, if you want everything this way, would be to go to Regional Settings in Control Panel and change the description of Short Date to give you all four digits. Example Format property for a control: hh:mm -- Wayne Morgan Microsoft Access MVP "scott" wrote in message ... Hi, I have an operations database that tracks our tug boat voyages and use the standard 24 hour timeclock. The times are shown with the short time format, but I need all 4 digits to show. In the maritime world, time is always shown in 4 digits. In Excel you can do it by setting the format to [hh]:mm Supposedly, if Excel can do it, Access can too. So how does it? Thanks, Captain Scott Carter Sause Brothers Inc Honolulu Hawaii |
#8
|
|||
|
|||
Time Format - Need all 4 digits shown
Perhaps, you need to set the same format on the Control(s) in the Report.
-- HTH Van T. Dinh MVP (Access) "scott" wrote in message ... For the life of me I believe that this is what I already tried...But I will check it tmro when I get back to work. I couldn't find the details of the format code [hh]:nn in help. Is that what forces the leading zero? I suppose its possible that it can show with the leading zero in a query, but not come thru in the report with the same data? I'll try to go back to the entry level data (the table where it is initally placed) and check the properties for that control. Thanks for the quick replies, Scott |
#9
|
|||
|
|||
Time Format - Need all 4 digits shown
Scott,
I just tried this again and Access is insisting on "helping" me out by changing hh:nn to Short Time and dropping the leading zero. To bypass this "help", make the control a calculated control. Control Source: =Format([FieldName], "hh:nn") Actually, I just tried this, it still insisted and changing "hh:nn" to "Short Time", but it left the leading zero in when I went to print preview. -- Wayne Morgan MS Access MVP "scott" wrote in message ... For the life of me I believe that this is what I already tried...But I will check it tmro when I get back to work. I couldn't find the details of the format code [hh]:nn in help. Is that what forces the leading zero? I suppose its possible that it can show with the leading zero in a query, but not come thru in the report with the same data? I'll try to go back to the entry level data (the table where it is initally placed) and check the properties for that control. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Round/Display (HR:MN:SEC) data in decimal HR format for Time Card | CRAIG.JOHNSON | General Discussion | 8 | March 26th, 2009 05:34 PM |
Function to add up total time taken? | Tails | New Users | 1 | August 9th, 2004 07:32 AM |
changing time format when concatenating | stewdawg35 | Worksheet Functions | 1 | July 28th, 2004 04:13 PM |
email format | Lloyd | General Discussion | 1 | June 16th, 2004 03:42 AM |
Outlook 2003 Terminal Server Time Zone issue | Robert Strom | Calendar | 2 | May 26th, 2004 10:50 PM |