validation

Question	Answer
Field length check	Field length check only allows a specific number of characters to be entered e.g to ensure exactly 11 numbers are entered into the field not 10-12.
Type check	Type check only allows a certain type of data to be entered, e.g text, number, currency, date/time, Boolean(Yes/No).
Range check	Range check only allows number's within a certain range, e.g between 1-100.
List check	List check only allows a specific data can be entered, e.g male or female.
Presence check	Presence check is to make sure a box is not left empty when its is needed e.g email on a delivery.
Format check	Format check is to make sure data is entered in a specific way, e.g including a space between the first and last part of a postcode.

Resource summary

	Created by Max Pryce-Jones about 5 years ago