List box and SQLDateTime

[muppetmad]

I Have a list box that displays several fields for each recordthe user is able to double click on the row and open the Data-entry form for the specilied record.

Of the fields in the list box 3 are Datetime (SQL) The data displays as The Date and time together. I only want to see the time for the 3 fields. On the dataentry form I changed the format to medium date. and that is what I would like to display in my list.

Is there a way to format the data in SQL to be time only or on the list box?

 

[boblarson]

Use a QUERY for the rowsource of the listbox and then in that you can format the field to look however you want it, for example in the QBE grid you would have:

MyNewDateFieldName:Format([MyOldDateFieldName], "Short Date")