Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access courses - Data validation in Ms access
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
microsoft access courses - Data validation in Ms access
Resolved · Low Priority · Version Standard
Reply Fri 13 Jul 2007, 17:21Delegate Dave said...
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
For upcoming training course dates see: Pricing & availability
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
Reply Fri 23 May 2008, 14:44Delegate John said...
RE: Data validation in Ms access
Very useful
|