Set DTPicker to display Null value?

[lywong111]

Realise DTPicker by default will display today's Date. Is there anyway to set the control to always display NULL until I clicked on the calender??
Read from somewhere that I need to set the CheckBox property to True inorder to have NULL value. But I doesn't want checkbox to appear in my control.
Any other alternatives??

Thanks in advance

 

[Nikita6003]

Hiya,

don't think there is an easy way unless you don't mind the checkbox.
However, take a look here:

http://www.devcity.net/forums/topic.asp?tid=52538

Some code to add a textbox to cover your DTPicker date display. Written for VB6 but should also work for VBA

HTH


Cheers
Nikki
Look, mommy, I'm flying!