restricting date text box between certain dates

[HeyInKy]

My userform uses a date picker, so all dates entered in the text box "txtsumfrom" will be in (USA) short date format. I had code to allow blanks, and to ensure the value was in date format (in case they wrote over the dater picker) - but I also want to add a rule that the entered date could not be before a certain date (in this case, 7/1/14) or a future date). So I added the code highlighted below. I don't get an error (yay me, I'm learning!), but it doesn't work either!

I also need to know what code to not allow the dates. As is, it just is suppose to give the message box, but will still allow the forbidden date value. Any help is greatly appreciated!

Please Login or Register  to view this content.

-HeyInKy

[buran]

Why not use mindate property of datepicker control?

[HeyInKy]

Why not use mindate property of datepicker control?

I could try, but A) I didn't write the code for the date picker (downloaded from the internet) - too complex for my current skill level, and kind of afraid to mess too much with it; and B) still doesn't address the problem if the enduser types the date manually and does not use the date picker.

[buran]

You can set mindate during design phase, not in the code. It doesn't' matter if user types the date manually - it's still not allowed.

[buran]

I read your post for second time. Do you really use DatePicker control or you expect user to enter date in a TextBox control? Note that these are two different types of controls and if you are using textbox, then my suggestion is not correct.

[HeyInKy]

I read your post for second time. Do you really use DatePicker control or you expect user to enter date in a TextBox control? Note that these are two different types of controls and if you are using textbox, then my suggestion is not correct.

Perhaps I misspoke... I'm using a text box with a date picker form that the enduser has the option of using. I don't know for sure, but my guess is that about half of the users will type manually because its quicker than reaching for the mouse, but I suspect many of the slower typers and those not used to tabbing through a form will use the date picker form, activated by a small command button placed next to the date text box.

My fault for not being too clear on that.