format problem using msacess database

[Guest]

hi iam using vs.net 2003, vb.net,Ado.net
msacess, a field is date/time
and format dd-mmm-yy hh:nn:ss

when i try to use this

dr("insp_datetime") = Format(Convert.ToDateTime(D), "dd-MMM-yy HH:mm:ss")
but the data in msaccess looks like this
24-Feb-06 0:00:00
i want to appear in like this 24-Feb-06 14:20:54

any formating iam missing....

thanks

 

[Guest]

sorry where D is
Dim D As Date
D = f ' note F looks like Thu, 16 Feb 2006 14:11:29