![]() This rule is applied when you enter data into the field. When you select a field in table design, you see its Validation Rule property in the lower pane. This article explains how to use validation rules, and concludes with some thought provoking on when to use them. ![]() (Some versions accept Nulls anyway, but we recommend you make it explicit for clarity and consistency.) If you need to be able to leave the field blank, add OR Is Null to your rule. you must enter something that satisfies the rule. In some versions of Access, you will not be able to leave the field blank once you add the validation rule, i.e. You can create a rule for a field (lower pane of table design), or for the table (in the Properties box in table design.) Use the table's rule to compare fields. Basically, they look like criteria in a query. Validation rules prevent bad data being saved in your table. Microsoft Access tips: Validation Rules Microsoft Access Tips for Casual Usersīy Allen Browne.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |