DTPicker problem...URGENT!!!

I'm using the drpShrtTime DTPicker...the problem is when it is added to the database...it prints the date also...and after trying to format the time...it still shows the seconds...

try something like

Code:

---

adoRS.Fields("YourTimeField") = format(DTPicker.Value,"hh:mm AMPM")

---

you might wanna go into the database and edit the field in the table itself.

i.e. in Access databases you can set the Format property of the field to "Short Time"