get the value of MSComCtl2.DTPicker.2 with VBA

[Guest]

Hi, thanks in advance for the hekp. I inserted DTPicker in a form and I named
DatetoSearch in order to get the value I use this

Me!DatetoSearch.Value

And Allway bring me 12:00:00 am even if I change these value in properties

Any Idea?

 

[Guest]

I don't know that much about DTPicker, but it sounds like you need to specify
the format for the output. Presumably, 12:00:00 am is just the first (or
last) part of the entire date which would consist of the date AND time. Check
out this MSDN link:

http://msdn.microsoft.com/library/d...on98/html/vbconusingdatetimepickercontrol.asp