Time format in an Unbound Text box problem

[Guest]

Hi all, on one of my forms, I have an ubound text box driven by a query. My
time text box, current_time is set to Short Time in my table as well as my
form. (Time is entered manually since I cannot figure out how to use an
auto-time that SAVES to my table)

In my unbound TB however (code from my query below) it shows up as Hours,
Mins, Secs and AM/PM.

Can anyone help me with this?

Thanks!
Steph


SELECT DISTINCTROW tblChronoLog.ChronoID, tblChronoLog.MONTH,
tblChronoLog.DAY, tblChronoLog.current_time, tblChronoLog.Watch,
tblChronoLog.ChronoEntry
FROM tblChronoLog
ORDER BY tblChronoLog.MONTH DESC , tblChronoLog.DAY DESC ,
tblChronoLog.current_time DESC;

 

[Guest]

You're going to have to change the format of the text box on the form as
well. The reason for this is that the date you see is actually a default
formatting of a number that represents the date. This number doesn't change
regardless of the format you view it in. So, unless you specify a date
format, access uses the default date format. I'm guessing you already know
how to do this, but in case you don't... Open the form in design view and
right click on the date field you want to format. Go to Properties and click
on the format tab. Then, on the format row, click on the drop down menu for
a selection of standard date formats, or you can customize your own. My
personal fave is m/dd/yy which produces results like "6/14/07". It save a
little space. Take care.

 

[Guest]

Jaybird, thanks for the response.

My text box is already set to Short Time, which is what I am after. That
seems to work fine. But on my Unbound Text box, it still comes out as the
full time.

Thanks again!