Validation

[mis]

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

 

[WayneRyan]

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

 

[mis]

Thanks

Hi

Thanks for your reply

 

[Pat Hartman]

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.