Short time display problem on form

[Lloyd]

I am using the "Short Time" format to display time in a 24 hour format but
when I type in a time that starts with a zero (ie. 00:30) it does not display
the first zero. Instead it displays 0:30 and not 00:30 as I would like. Any
help?

 

[Stuart McCall]

I am using the "Short Time" format to display time in a 24 hour format but
when I type in a time that starts with a zero (ie. 00:30) it does not
display
the first zero. Instead it displays 0:30 and not 00:30 as I would like.
Any
help?

Replace 'Short Time' with 'hh:nn'

 

[Lloyd]

I tried as you suggested but access 2007 changes hh:nn to "short date" and
the problem continues. It wont allow hh:nn by itself. Another idea?

 

[Pete D.]

Is it a properly formated text box?

I tried as you suggested but access 2007 changes hh:nn to "short date" and
the problem continues. It wont allow hh:nn by itself. Another idea?

 

[Stuart McCall]

I tried as you suggested but access 2007 changes hh:nn to "short date" and
the problem continues. It wont allow hh:nn by itself. Another idea?

Try setting the property via code in the form's Load event:

Me.TextboxName.Format = "hh:nn"

 

[Jeff Boyce]

Lloyd

I don't recall seeing anywhere that the underlying field on which you are
attempting this is, in fact, an Access Date/Time field. Can you confirm
this?

Regards

Jeff Boyce
Microsoft Office/Access MVP