Validation Rule

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

Guest

In response to a required message the following was used at the table level:
([Surname] Is Not Null)AND ([City] Is Not Null) AND....

I have required fields that have a default value and could be null,example:
Severity should be 1,2,or 3 the default is 3
Resolution Status: In Progress or Complete,the default is ..In Progress
How do I code this at the validation rule at the table level and can I use
IsNull ?
 
This would probably be better handled in a form's BeforeUpdate event;
however, it is doable in a table. Open the table in design view, right click
the area at the top where the fields are listed, and choose Properties. This
will be the properties for the table. You can put a multifield validation
rule in there. Yes, you can check for Null

[Field1] Is Null
and
IsNull([Field1])

will both work.

Now, about your required fields, if they are required, how can they be Null?
 
Back
Top