Validating date field

If the rules are mutually exclusive, they prevent you from entering any data at all.

validating date field-81

When you define rules for tables, those rules apply when you import data.

To add validation rules to a table, you open the table and use commands on the Fields tab of the ribbon.

The steps in the section Add a validation rule to a control on a form, later in this article, explain how to add rules to the properties in individual controls.

Your validation rules can contain expressions — functions that return a single value.

By default, all .accdb and files use the ANSI-89 standard.

If the validation rule you're looking for isn't in the list above, it's easy to create your own custom rule.Typically, your database is easier to use if you use IS NOT NULL and enter a friendly message in the Validation Text property.You can use wildcard characters in your validation rules.Usually, a record validation rule compares the values of two or more fields.Tip: If you create a form automatically from a table by using one of the Form commands on the ribbon, any validation for fields in the underlying table are inherited by the corresponding controls on the form.For more information about data types, field sizes, and input masks, see the article Introduction to data types and field properties.

Tags: , ,