Member Avatar for pokahantos

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..

  • 3 Contributors
  • 2 Replies
  • 84 Views
  • 1 Month Discussion Span
  • Latest Post Latest Post by roubesh14

Recommended Answers

All 2 Replies

Member Avatar for msaqib

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.

Member Avatar for roubesh14

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.