microsoft access courses - Data validation in Ms access

Hi Dave

To do data validation correctly with Microsoft Access 2002, you really need to write some code within vba that will check the input from the forms and make sure that go through the rules that you have set. If they fail then you can display an message box asking the using to try again and explain the format required. Alternatively if you do not want to use vba, you can use a very basic form of validation known as an input mask. This checks that the input meets certain conditions, such as first letter of name is uppercase and the rest is lowercase, however if this is not set by the user, access will automatically convert it to the requirements of the input mask.

Hope this helps
David