Take a look at this quick and clear explanation of how to set Validation Rules in Microsoft Access via a table. The validation rules use the same logical expressions that can be found typically in criteria of a query and must return a logical value of either TRUE or FALSE in order to accept or reject the value and trigger an exception (validation text property). This simple property is easier to apply than attaching a macro or VBA code to […]

Tags: access 2007 table validation rules, access database validation rules, how to apply validation rules, microsoft access database, validation rules in a field