Format in an unbound Text Box

[Guest]

Hi all, I have a form that I have put an unbound text box in, which displays
the previous entries from my table. One of my fields is Current Time. Which
on my form I set to Short Date (military time).

How can I have my unbound text display Short time as well. here is my code
(control source of my unbound text box).

SELECT DISTINCTROW tblSITLog.[current time], tblSITLog.MONTH, tblSITLog.DAY,
tblSITLog.SIT, tblSITLog.[NATURE OF iNCIDENT], tblSITLog.[Case Description],
tblSITLog.Incident_Number
FROM tblSITLog
WHERE (((tblSITLog.[NATURE OF iNCIDENT])="CHRONO ENTRY"))
ORDER BY tblSITLog.Incident_Number DESC;


Thanks in advance,
Steph

 

[Guest]

Scuda --- isn't what your looking for a format property of the box on your
form to "Short Time"?

SteveD