Question

write validation rule in ms access for the user to enter age more than 18

Answer 1

Answer:

Field Validation Rule   You can use a field validation rule to specify a criterion that all valid field values must meet. You should not have to specify the current field as a part of the rule unless you are using the field in a function.  Restrictions on types of characters to be entered in a field may be easier to do with an Input Mask. For example, a date field might have a validation rule that disallows values in the past.

Quick examples:

Disallow date values in the past: >=Date()

Generally accepted email format: Is Null OR ((Like "*?@?*.?*") AND (Not Like "*[ ,;]*"))

Number less than or qual to five: <=5

Currency field can't be negative: >=0

Restrict character length in string: Len([StringFieldName])<100



2. Record Validation Rule   You can use a record validation rule to specify a condition that all valid records must satisfy. You can compare values across different fields using a record validation rule. For example, a record with two date fields might require that values of one field always precede values of the other field (e.g., StartDate is before EndDate).

Quick examples:

Ensure the end date doesn't come before the start date: [End Date]>=[Start Date]

Enter a required date that occurs no more than 30 days after the order date: [RequiredDate]<=[OrderDate]+30



3. Validation on a form   You can use the Validation Rule property of a control on a form to specify a criterion that all values input to that control must meet. The Validation Rule control property works like a field validation rule. Typically, you use a form validation rule instead of a field validation rule if the rule was specific only to that form and not to the table no matter where it was used.