Validation

mis

Registered User.
Local time
Today, 04:18
Joined
Dec 15, 2003
Messages
55
Hi,

I have seen some messages in the forums that show people placing validation though VBA and others using validation text/rules inside Access which is better ??

Cheers
 
mis,

Which is better? That depends ...

Easier to use the rules ...

But with VBA, you can bring up custom message boxes and/or forms to
direct the user. Looks nicer.

Wayne
 
Thanks

Hi

Thanks for your reply
 
If your validation can be done in the table, that is the best choice. Jet will enforce your validation rules no matter how the table gets updated. But, alas, Jet doesn't support triggers so it is far less flexible than other RDBMS' and so you will probably need to do much of your validation in form events.
 

Users who are viewing this thread

Back
Top Bottom