Unlike the above-mentioned field validation rule, using Record validation rules users can refer to some other fields present in the exact same table. This record validation rule is used to control data while saving a record. The message will pop-up when data violates the validation rule entered by the user. Using this option user can assign the alert message which appears to the user. This option is used to specify requirements for data inserted within the field. Mainly there are two boxes that relate to Field validation rules. Now you need to enter dates either on or after January 1, 2010. =# criteria in that specific field’s Validation Rule property. One way is to set the required property to the YES option that forces the users to put value in that particular field only.Īnother way is to make use of Validation Rule property which needs specific values and the Validation Text property for getting easy error alerts.Įg: suppose you are setting rules like this >40 And = Date( ) Out of these, table properties allow very precise and exact data validation types. MS Access gives you several options such as data types, field sizes, table properties, and input masks for validating the data. One can consider it as a set of layers that ensures the user’s entered data appropriately. Microsoft Access validation rule helps in restricting or controlling the user’s input in the table field. What’s The Need Of Using MS Access Validation Rule ? Performing such a task can be a complex one mainly if you are willing to test for many text variables. But you can make a validation rule for the text entries also. If your entered data doesn’t match the criteria applied for that field then it will show an error message and rejects your data.ĭata validation rule works great for number, time/date fields, and currency. Access data validation rule actually checks the inserting data by applying a specified set of rules.
MS Access validation rule is one of the best options to prevent data-entry errors. Fix Access Errors Understanding MS Access Validation Rule:
0 kommentar(er)
