PDA

View Full Version : DTPicker



Opv
07-31-2010, 12:29 PM
I have a DTPicker control (Excel 2000) in UserForm1. I have it disabled unless CheckBox1 (which is True by default) is changed to False (deselected).

I have the DTPicker disabled and not visible, with a value of "", by default. This effectively returns a value of "" when CheckBox is set to true. My problem, however, is that even with the DTPicker disabled and invisible, and even with a Value of "", it is still returning a value for the time. Is there a way to totally disable the time of day feature?

p45cal
07-31-2010, 03:41 PM
Try keeping its .visible property True, is the .value still a time? Here it's Null.
Setting its .Width to 0 might be a workaround.

Opv
07-31-2010, 03:54 PM
Try keeping its .visible property True, is the .value still a time? Here it's Null.
Setting its .Width to 0 might be a workaround.

Still having a problem. I think I found a way around it, however, by using a conditional statement to test whether DTPicker is enabled prior to generating the userform output.

Thanks,

Opv