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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top