Validation rules
Data is validated or checked to see if it meets certain rules when entered into a field. It cannot be checked for accuracy. For example, a validation rule may only allow mobile phone numbers that are 11 digits long, but the mobile number itself could be wrong.
- Field length check – only allows a specific number of characters to be entered.
- Range check – number entered must be within a certain range, eg between 1-100.
- List check – only specific data can be entered, eg male or female.
- Present check – the field cannot be left empty.
- Input mask – data must be entered in a specific way, eg including a space between the first and last part of a postcode.
