.| ValidationRule setting | ValidationText setting |
|---|---|
| <>0 | Please enter a nonzero value. |
| 0 Or >100 | Value must be either 0 or over 100. |
| Like "K???" | Value must be four characters beginning with the letter K. |
| <#1/1/96# | Enter a date before 1996. |
| >=#1/1/97# And <#1/1/98# | Date must be in 1997. |
| StrComp(UCase([LastName]), [LastName],0) = 0 |
Data in the LastName field must be entered in uppercase letters. |
Read about validation rules.
Note For an example of setting form-level validation with a macro or event procedure, click .