listbox date display

J

JohnE

Greetings. I have a form that has a listbox on it. The table it draws from
stores dates as mmddyyyy. In the txtbox on the form I have the dates show as
mm-dd-yyyy. How can I have the dates in the list box also show as they do on
the form rather then the table? Here is the part of the code that populates
the listbox on the form. It is the DateOfEntry that has the date.
"SELECT " & _
"AccountManagementUpdateID, " & _
"ClientCode, " & _
"DateOfEntry, " & _
"SpecialtyItemStatus, " & _
"SpecialtyItemTopic " & _
"From usrtblAccountManagementUpdate " & _
"WHERE (((ClientCode) =
[Forms]![usrfrmClientSelection]![ClientCode])) " & _
"AND (SpecialtyItemStatus) = ""Open"" " & _
"ORDER BY SpecialtyItemTopic;"

Thanks to those who respond.
*** John
 
G

Graham R Seach

John,

"Format(DateOfEntry, 'mm-dd-yyyy') As EntryDate, " & _

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
J

JohnE

Graham, thanks for the info. It worked like a charm.
*** John


Graham R Seach said:
John,

"Format(DateOfEntry, 'mm-dd-yyyy') As EntryDate, " & _

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

JohnE said:
Greetings. I have a form that has a listbox on it. The table it draws
from
stores dates as mmddyyyy. In the txtbox on the form I have the dates show
as
mm-dd-yyyy. How can I have the dates in the list box also show as they do
on
the form rather then the table? Here is the part of the code that
populates
the listbox on the form. It is the DateOfEntry that has the date.
"SELECT " & _
"AccountManagementUpdateID, " & _
"ClientCode, " & _
"DateOfEntry, " & _
"SpecialtyItemStatus, " & _
"SpecialtyItemTopic " & _
"From usrtblAccountManagementUpdate " & _
"WHERE (((ClientCode) =
[Forms]![usrfrmClientSelection]![ClientCode])) " & _
"AND (SpecialtyItemStatus) = ""Open"" " & _
"ORDER BY SpecialtyItemTopic;"

Thanks to those who respond.
*** John
Click to expand...
Click to expand...
 
Top