Validating Date

[Guest]

I have a StartDate and an EndDate textbox on a form that's unbound. How can I
validate when the user click on a command button, i.e., April 31, 2006 is
invalidate because April does not have 31 days? For now everytime an invalid
date is entered Access shows a non-user-friendly message. Thanks in advance.

 

[Guest]

Try using the IsDate Function

If IsDate(Me.[TextFieldName]) Then
....
End If

 

[Barry Gilbert]

In the textbox's BeforeUpdate event put this code:

If Not IsDate(Me.StartDate) Then
Msgbox "Invalid date"
Cancel=True
Endif

This will validate the date before ever getting to the command button.

HTH,
Barry

 

[Guest]

Many thanks to Ofer and Barry! Both methods work flawlessly!