easy question ... Date format

[ting2000]

Hi there,
How do I check if a text box is entered with a valid date format not just some characters?? Thanks.

[Iain17]

you can use the "IsDate" function.

If IsDate(text1.text) then
  msgbox "Valid"
Else
  msgbox "InValid"
End If

[woodyaj]

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.

[ting2000]

Thanks you guys!! \\(^0^)//