Change time

  • Thread starter Thread starter AHopper
  • Start date Start date
A

AHopper

Is there a way to change the standard time entered through
a text box to military time?

Example
11 PM to 23

I would like to us the After Update event of
the "PackTime" text box and have the changed time show in
a second text box "PackMTime".

Thanks for your help

Allan
 
Hello Allan

The data isn't changing here - only the way it's being displayed - ie the
Format property.

Set the ControlSource of your second textbox to =[PackTime] and its Format
to hh (or hh:nn if you want the minutes as well). No AfterUpdate event
required!
 
-----Original Message-----
Is there a way to change the standard time entered through
a text box to military time?

Example
11 PM to 23

I would like to us the After Update event of
the "PackTime" text box and have the changed time show in
a second text box "PackMTime".

Thanks for your help

Allan
Click to expand...
Hi Allan, no need to use the AfterUpdate event. Have the
second textbox set to the same field as control source.
Then set the format property of this second textbox to
short time.

Luck
Jonathan
 
Is there a way to change the standard time entered through
a text box to military time?

Example
11 PM to 23

I would like to us the After Update event of
the "PackTime" text box and have the changed time show in
a second text box "PackMTime".
Click to expand...

A Date/Time field is stored internally as a Double Float number; the
format can vary widely. I'd suggest using just one textbox; set its
Format property to "hh:nn". This will allow you to enter 23:00 or
11:00 PM, but will display the stored time as 23:00.
 
Thank you Graham.
Allan
-----Original Message-----
Hello Allan

The data isn't changing here - only the way it's being displayed - ie the
Format property.

Set the ControlSource of your second textbox to = [PackTime] and its Format
to hh (or hh:nn if you want the minutes as well). No AfterUpdate event
required!

--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

Is there a way to change the standard time entered through
a text box to military time?

Example
11 PM to 23

I would like to us the After Update event of
the "PackTime" text box and have the changed time show in
a second text box "PackMTime".

Thanks for your help

Allan
Click to expand...


.
Click to expand...
 
Thank you Jonathan
Allan
-----Original Message-----

Hi Allan, no need to use the AfterUpdate event. Have the
second textbox set to the same field as control source.
Then set the format property of this second textbox to
short time.

Luck
Jonathan
.
Click to expand...
 
Back
Top