Custom warning

[Guest]

In my database I have a linked table from SQL-server.
In the table there is field "BranchID". The "Allow Nulls" property of the
field is set to "No".
In my database there is a form for entering records to that table.
The control-field "BranchID" has the following properties:

ValidationRule = Is Not Null
ValidationText = "My message text"

But when a user enters some value into the field and then deletes it, he
gets the following message:

<You tried to assign the Null value to a variable that is not a Variant data
type>

instead of "My message text".

How can I force the form to show my custom warning?

 

[Guest]

It seems like you added the rule to the table after creating the form.

To fix this go to your form design and verify for that field that the
ValidationRule & Text are filled in.

After filling in those two fields you should be fine.