Validating text box entries 100 dating sites for new zealanders
Validation text lets you provide a message to help users who input data that is not valid.When data is entered, Access checks to see whether the input breaks a validation rule – if so, the input is not accepted, and Access displays a message.You can use an expression to perform calculations, manipulate characters, or test data. For example, an expression can check for one of a series of values, such as "Tokyo" Or "Moscow" Or "Paris" Or "Helsinki".Expressions can also perform mathematical operations. For example, the expression You can add a field validation rule and/or a record 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.For more information about data types, field sizes, and input masks, see the article Introduction to data types and field properties.