Validation Text

[rm]

How do I get rid of the less then friendly "The value you entered
isn't valid for this field" message?

Validation Text = "Please Enter a Valid Date"
Validation Rule = "Is Null Or IsDate([dob])=True"

When the user enters an invalid date I still get the "The value you
entered.." message. How do I make the Validation Text display instead.

I tried Before Update on the control. Searching through the group I
see a suggestion of Before Update on the form. Is that possible? I am
not sure? I will look.

 

[Rui]

in the form before update event type something like:

Private Sub Form_BeforeUpdate(Cancel As Integer)
If IsNull(Me.Text0.value) Then
MsgBox ("missing")
Cancel = True
End If
If IsNull(Me.Text3.value) Then
MsgBox ("missing 3")
Cancel = True
End If
End Sub