DTPicker Lock property

  • Thread starter Thread starter Ayo
  • Start date Start date
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
 
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
 
--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
 
Back
Top