Validation

[Craig Willetts]

Hello

I'm using Microsoft Access 2002,

In my table I have a field for E-Mail Address's and I
want that field to display a error message when an @ sign
is not entered using Validation.

Please Help, Thanks

 

[Tim Ferguson]

In my table I have a field for E-Mail Address's and I
want that field to display a error message when an @ sign
is not entered using Validation.

Set the ValidationRule to

LIKE "*@*" OR IS NULL

Hope that helps


Tim F