Hi,

I need to validate an entry in my Access db to ensure that it is an email..
how can i do that...

how can i make a specific feild to accept NUll?

Thanks in advance..

You can use the expression builder in Acess to validate the email address before entering, or if you are using any software to enter the data then you can validate the email address using the code.

split the string on " @ " and re split on " . " and its done

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.