TheSearcher
Registered User.
- Local time
- Today, 08:38
- Joined
- Jul 21, 2011
- Messages
- 304
I have the following code behind a command button. However, it accepts a three digit year as being valid - ex: 8/26/202. Why would this be?
'Validate Data
If IsDate(txt_DateOfIncident.Value) = False Then
MsgBox "You must enter a valid date.", vbCritical, "INVALID DATE"
txt_DateOfIncident = ""
txt_DateOfIncident.SetFocus
Exit Sub
End If
Thanks,
TS
'Validate Data
If IsDate(txt_DateOfIncident.Value) = False Then
MsgBox "You must enter a valid date.", vbCritical, "INVALID DATE"
txt_DateOfIncident = ""
txt_DateOfIncident.SetFocus
Exit Sub
End If
Thanks,
TS