Access2 time formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Has anyone encountered this scenario before
I have a short time format hh:mm, 24hr, field in a table
I use a query to pull this data into a combox box
When I bind a text box to the combo box the time is formatting itself hh:mm:ss and all are tagged with PM, regardless of time
I have tried formatting in code and in properties and it's just not doing affecting it
I can't understand why it is applying this formatting to this field
Can anyone advise
 
Stephen said:
Has anyone encountered this scenario before.
I have a short time format hh:mm, 24hr, field in a table.
I use a query to pull this data into a combox box.
When I bind a text box to the combo box the time is formatting itself hh:mm:ss and all are tagged with PM, regardless of time.
I have tried formatting in code and in properties and it's just not doing affecting it.
I can't understand why it is applying this formatting to this field.
Click to expand...

What do you mean by "bind a text box to the combo box"?

Actually, this sounds like the combo box is returning a
string and not a date/time value. Try converting the value
to a date/time in the text box:

=CDate(combo)
 
Back
Top