Field Validation message

[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

 

[Allen Browne]

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

 

[Guest]

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.