I have a customer details form where the email address entered should have one and only one "@" and that this is neither the first nor the last character.
I have used the following code to try to achieve this but it does not stop the @ sign being entered as the first or last character. It also allows more than 1 @ sign to be entered:
Is Null Or ((Like "*??@??*.??*") And (Not Like "*[ ,;]*"))
Any ideas anyone?