Custom warning

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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.
 
Back
Top