Required property not being enforced

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

Guest

I have a table where 4 fields have their Required property set to Yes. When I
enter data into the table, Access is only enforcing this for one of the
fields, meaning I can add records where Required fields are blank. All of the
fields which this is happening to are the subject of lookups from other
tables. The one field which works is not a lookup (it's a date field which
the user types in).

How can I enforce the Required property for these fields?
 
Is the AllowZeroLength property to Yes for those field? If so a zero-length
string will be a valid entry in the field regardless of the Required property
setting. A ZLS and Null are not the same thing. Also spaces are not the same
as a Null.

When confonted with an empty looking field that isn't working as expected, I
check the data with queries looking for things such as Like " *" ; Null; and
"" .
 
The AllowZeroLength property isn't there for these fields. I'm assuming that
this is because I've specified them as Lookup fields. AllowZeroLength is
there for the fields which aren't lookups.
 
Your problems may be an unintended consequence of using Lookup fields
in tables. There are a few.

Lookup fields don't get much support in the Access newsgroups. You
might visit www.mvps.org/access for a discussion of the issue.

HTH
 
Back
Top