Is Not Null v Required

  • Thread starter Thread starter Alex H
  • Start date Start date
A

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
 
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.
 
Thanks
Allen Browne said:
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.
Click to expand...
 
Back
Top