Tom has attended:
Access Intermediate course
Access Advanced course
Validation
What validation rules can I set in design mode for entering data into a field?
RE: Validation
Hi Tom
Data validation is quite a large area within access, thus I can only give a few examples of data validation, otherwise this will be an extremely long post. Basically you validate anything that is not random, for example:
The first few characters within the 1st line of an address can either be a number or a letter, then the rest must be letters.
A phone number must be number entries (you can even set a pattern for entry)
A post code must start with a letter
Hope this helps
David