Database Reference
In-Depth Information
Making Validation Stricter
Your Zip Code field validation options work pretty well, but there's a pretty glaring problem:
Anybody can enter just about anything they want and then click Yes to tell FileMaker to ac-
cept the invalid data. It may help prevent mistakes, but it doesn't ensure good information.
To make FileMaker more insistent, revisit the “Options for Field” dialog box's Validation tab
and then turn off the “Allow user to override during data entry” checkbox (it's near the top of
the window). Since this change removes the “Yes” and “No” choices when entering data, you
also want to reword the custom message you entered. Change it to something more informat-
ive, like
Zip Codes can contain no more than five numerals. Letters and symbols are not per-
mitted. Please check your data entry and try again
.
