formatting shouldn't be part of the data layer ie in a query, unless you have a need to do some processing on that format (say if you wanted to do some selecting or ordering based on days or months). Formatting is a function of the presentation layer, ie in the report or form using that data. Set an appropriate format in the control on the report / form using that column
likely candidate are medium date, or write you own format mask.
Formatting in the report was causing problems because the field is concatenated with the text “Start Time:” The reason for this is because I am trying to remove blank space from the report which is why I used the (text+[field]) in the query instead of a label on the report.
I assume Access now thinks it is a string and will only give the time in 24h format with the prefixed text. I tried adding a format mask in the control on the report but it still shows as 24h time. Any suggestions on forcing the format or should I just ditch the prefixed text?