Hi Richard, is there a way to allow the Validation Rule property to accept Null values? If someone enters in a default value to remove the blanks, might it just get lumped in with the rest of the Table's data as "known" data (rather than data you would like to have checked) and then your Table winds up with some "bad data" (which is worse than "no data"), just to get the Validation Rule to work? Thanks a lot!
Reply from Alex Hedley:
You can add OR Is Null to your rule
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 3.
