Custom Validation Text not appearing

W

wersh

I created a Validation Text message for a required field, but the default
message appears instead. How do I correct this?
 
J

Jeanette Cunningham

Hi wersh,
assuming the validation text is in the table, you can use error trapping to
hide the default message that shows when you are using the form.
That message comes from the form's error event and to trap it, you need to
put code in the form's error event something like this-->

If DataErr = 3314 Then
MsgBox "A value is required. Correct entry or press Esc to cancel."
Response = acDataErrContinue
End If


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
Top