Field Validation message

R

Ronnie

Hi if you have a table field with its required property
set to Yes and the field is not filled with data you get
an error on the form when trying to save the form. I
would like to display my own error message instead and
title it as you would in vb.

Can someone explain for me how to do this?

Thanks

Ronnie
 
A

Allen Browne

Use the Error event of the form to trap the error and provide your own
MsgBox.
 
T

Tru

Here are the steps to create your own error message.

1: Go to your table in design mode
2: Type in the Validation Rule: Is Not Null
3: Type in the Validation Text your Error Message: You must complete this
field
4: Required: No
5: Allow Zero length: No

It works for me.
 
Top