Format in an unbound Text Box

S

Scuda

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
 
S

SteveD

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

SteveD
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top