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

Similar Threads

problem with query 5
Creating a Search using a combo box and then creating a report. 4
Word OLE to check spelling in text box 1
Unable to display values in 2nd list box from 1st list box selection 2
Format unbound Text Box 3
formating an unbound text box 1
How to Import Formatted text as new Slides in PowerPoint 0
Unbound control on continuous form goes blank 1

Top