Hi there,
How do I check if a text box is entered with a valid date format not just some characters?? Thanks.
Printable View
Hi there,
How do I check if a text box is entered with a valid date format not just some characters?? Thanks.
you can use the "IsDate" function.
Code:If IsDate(text1.text) then
msgbox "Valid"
Else
msgbox "InValid"
End If
In the lostfocus section for the control, use the ISDATE function. The syntax is covered quite well in the help text.
Check if the box is empty first, and if not, use isdate.
Thanks you guys!! \\(^0^)//