In my Access table I have a time field formatted as medium time (hh:mm AM/PM). However when I display it on my HTML using ASP is shows up as a long date (HH:MM:SS AM/PM) which just shows too many zeros as it is just an hourly type time field. I have found info on making it short or long but can find nothing on making it display as medium and I need the AM/PM for sorting purposes. It seems it should display as medium by default since it is medium in the table? Below is the code displaying the time. Does anyone have a suggestion? "Event_Time" is the field name.
Response.Write "[B]<FONT FACE='Verdana, Arial' SIZE='1' COLOR='Red'>" & vbCrLf
Response.Write Replace(Rs("Event_Time") & " ", vbCrLf, "") & vbCrLf
Response.Write "</FONT>" & vbCrLf