Time Formatting

  • Thread starter Thread starter DS
  • Start date Start date
D

DS

I have this expression that I need to format.

Me.Text102 = Me.List66.Column(3) & " " & Me.List66.Column(4) & "
TO " & Me.List66.Column(5)

Right Now I'm getting this...

Lunch 7:00:00 AM TO 8:00:00 PM

I need...

Lunch 7:00 AM TO 8:00 PM

Me.List.Column(4) and Me.List.Column(5) are the Time Fields.

Thanks
DS
 
Try ............
Me.Text102 = Me.List66.Column(3) & " " & Format(Me.List66.Column(4), "h:nn")
& " TO " & Format(Me.List66.Column(5), "h:nn")

R. Hicks
 
Ricky said:
Try ............
Me.Text102 = Me.List66.Column(3) & " " & Format(Me.List66.Column(4), "h:nn")
& " TO " & Format(Me.List66.Column(5), "h:nn")

R. Hicks

:
Click to expand...
Thanks
Worked Great!
DS
 
Back
Top