Formatting a Txtbox to Display Time

  • Thread starter Thread starter John C.
  • Start date Start date
J

John C.

I have a field for Date/Time.

I have tried formatting the field to hh:nn (no quotes) but
it defaults back to Short Time (which only displays h:nn).

I have tried using "hh:nn" (with quotes), but then all
that is displayed is just that, hh:nn (no quotes).

I have tried changing this field to a text, same thing
occurs.

I would like to have "01:30" (no quotes) displayed.
Basically, military time is needed.

Thankyou in advance. Hope everyone has recovered from New
Years.
 
John said:
I have a field for Date/Time.

I have tried formatting the field to hh:nn (no quotes) but
it defaults back to Short Time (which only displays h:nn).

I have tried using "hh:nn" (with quotes), but then all
that is displayed is just that, hh:nn (no quotes).

I have tried changing this field to a text, same thing
occurs.

I would like to have "01:30" (no quotes) displayed.
Basically, military time is needed.
Click to expand...


Irritating isn't it. If this is an editable text box,
fixing it is kind of messy. Place another text box of the
same size exactly on top of the current text box (use Format
- Bring to Front if needed). Set this new text box's
Control Source expression to:
=Format(originaltextbox, "hh:nn")

Now, use code in the new text box's GotFocus event to reset
the focus to the original text box.
originaltextbox.SetFocus

If users can not enter the time, then just use the format
function:
=Format(dtfield, "hh:nn")
 
Back
Top