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

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

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

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

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

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

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

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

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.