如何在Access中验证电子邮件地址? [英] How to validate email addresses in Access?

问题描述

我需要验证Access 2010中表中的电子邮件字段.我尝试过:

I need to validate an email field in a table in Access 2010. I tried:

Is Null OR ((Like "*?@?*.?*") AND
  (Not Like "*[ ,;]*"))

但是这没有用.

推荐答案

看来您的数据库处于ANSI 92模式，并且在粘贴规则时...

It appears that your database is in ANSI 92 mode, and when you pasted in the rule...

Is Null OR ((Like "*?@?*.?*") AND (Not Like "*[ ,;]*"))

...访问权限自动从Like更改为ALike，产生...

...Access automatically changed Like to ALike, producing...

Is Null Or ((ALike "*?@?*.?*") And (Not ALike "*[ ,;]*"))

问题在于ALike使用ANSI通配符，因此您需要将规则更改为

The problem is that ALike uses the ANSI wildcard characters, so you need to change the rule to

Is Null Or ((ALike "%_@_%._%") And (Not ALike "%[ ,;]%"))

这篇关于如何在Access中验证电子邮件地址?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！