Error Check Dates
IF ISDATE(me.Textbox1.Text) then...
but you may want to further check years, because you MIGHT have a year of
3081, so maybe
IF Isdate(me.textbox1.Text) then
IF Year(me.textbox1.text)2100 then 'arbitrary year here
MsgBox "Invalid Date"
etc.
"jlclyde" wrote:
I have a user form that I would like people to enter dates, I woudl
like to check to make sure that they are indeed dates. What is the
error checking for this? Could someone help with this?
Thanks,
Jay
|