Is Not Null v Required

[Alex H]

Hi IN a table design is it better to have the Validation Control set to Is
Not Null or the Required Control set to Yes, if I want to force someone to
enter data into a field.

Thanks

Alex

 

[Allen Browne]

Exactly the same result.

Required is simpler.

Validation Rule lets you specify a Validation Text.

Either way, be sure to set Allow Zero Length to No for all your Text, Memo,
and Hyperlink fields, so you never end up with a zero-length string in the
field.

 

[Alex H]

Thanks

Exactly the same result.

Required is simpler.

Validation Rule lets you specify a Validation Text.

Either way, be sure to set Allow Zero Length to No for all your Text,
Memo, and Hyperlink fields, so you never end up with a zero-length string
in the field.