microsoft access 2013 tutorial 5 case problem 4

Remove the '=' if zero is not allowed either.ġ00% is 1. The question mark stands for one character. Is Null OR Not Like '**'Īccepts A to Z and 0 to 9, but no punctuation or other characters. (Decimal point and negative sign rejected.) (Case insensitive.)Īny character outside the range 0 to 9 is rejected. You cannot tab to the next field until you enter something that satisfies the rule, or undo your entry.Īny character outside the range A to Z is rejected. 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.

Microsoft access 2013 tutorial 5 case problem 4