Textbox on form

[IanT]

Hi
I have a textbox on a form where a date will be input, I need code to validate that a date has been input into the textbox, can anyone help!

Ta

 

[boblarson]

In the text box's Before Update event you can put

If Not IsDate(Me.YourTextBoxNameHere.Text) Then
    MsgBox "You did not enter a valid date", vbExclamation, "Entry Error"
    Cancel = True
    Me.YourTextBoxNameHere.Undo
End If