![]() You can also use the Validation Rule property to require specific values, and the Validation Text property to alert your users to any mistakes. For example, the Field Size property of a field restricts input by limiting the amount of data. ![]() For example, a Date/Time field accepts only dates and times, a Currency field accepts only monetary data, and so on.įield properties Some field properties restrict data input. 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.Īccess provides a number of ways to restrict input:ĭata types Every table field has a data type that restricts what users can enter. Validation text lets you provide a message to help users who input data that is not valid. A validation rule is one way to restrict input in a table field or a control (such as a text box) on a form. This article explains how to use validation rules and validation text in table fields and form controls. Test existing data against a new validation ruleĪdd a validation rule to a control on a form 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. The Validation Rule control property works like a field validation rule. ![]() 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |