Time in Access: Keeping "medium time" format

[eepok]

I've run into a bug, I think. I have a time field with it set to show "Medium Time" which is "hh:mm(AM/PM)", however, when I combine the information with another field in a query (=[OfficeDay]&" - "&[POfficeTime]), the time comes out as "Long Time" or "hh:mm:ss(AM/PM)".

End result is Wednesday - 10:30:00AM when it should be Wednesday - 10:30AM

Does anyone know a way around this?

 

[pbaldy]

Personally I usually format things in the report or form they're destined for, but you can probably wrap the second part of your formula in the Format() function to have it come out the way you want.