DTPicker Lock property

A

Ayo

Is there a way to lock the DTPicker so that the value can't be changed? I
want to lock the DTPicker to prevent someone from accidentally making a
change to it. I was able to do that for the TextBoxes on the form but the
DTPicker does't have a property like that.
Is there a way to do that?
Thanks
 
B

Bernie Deitrick

Change the DTPicker's Enabled value from True to False. Of course, it will look washed out. If you
don't like that look, then store the Value and reassign it in one or more of the DTPicker's events.

HTH,
Bernie
MS Excel MVP
 
J

Jacob Skaria

--If you mean to lock at run time after the initial user selection; then why
not place a hidden text box and once the selection is made transfer that to a
text box and make is visible over dtpicker..

--If you mean althrough the user interaction then better place a text box
and display date formatted using Format(Date,"dd/m/yyyy") or any format which
you would prefer


If this post helps click Yes
 
Top