Dave has attended:
No courses
Data validation in Ms access
Hi,
I wanted to know how to do data validation in Microsoft access 2002. Any tips on data validation for my Microsoft access database tables would be great.
Thanks
David
RE: 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