Time Formatting

[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

 

[Guest]

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

R. Hicks

 

[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

:

Thanks
Worked Great!
DS

 

[Guest]

Glad you got it going ...

R. Hicks

Thanks
Worked Great!
DS