Access DB中电子邮件字段的数据类型 [英] Datatype for Email field in Access DB

问题描述

大家好，

我正在使用Access db编码应用程序.在我的应用程序中，我有一个电子邮件字段，该字段保存在access db中.那么，此字段的数据类型是什么?
任何输入掩码或验证规则?以及如何做??

谢谢您的帮助.

Hi everyone,

I am coding an application using access db. In my application I am having an email field which is saved in access db. So for this what will be the datatype for this field?
Any input mask or validation rule?? And how to do this??

Any help is kindly appreciated.

推荐答案

电子邮件没有特定的数据类型，因此，您唯一的选择是为检查您输入内容的字段创建验证规则.正确的方法，或者最好的方法是在用户界面本身中验证您的电子邮件.这样，您可以在提交数据库之前让用户知道存在问题.

希望对您有帮助

There is no specific datatype for email, so your only options are to either create a validation rule for the field that checks your entry is correct, or, the best way to do it would be to validate your email in the user interface itself. That way you can let the user know there is a problem before submitting to the database.

Hope this helps

您可以将Text声明为Email的数据类型
并确认输入的文字是
有效的电子邮件ID，建议您
遵循此链接[ ^ ]
希望这可以解决您的问题.
并了解有关Access数据库和表单的更多信息
请访问此链接[ ^ ]

You can declare Text as DataType for Email
and to validate it that the text entered is
Valid Email Id I suggest you to
Follow this Link [^]
May this Can Solve Your Problem.
And to Learn More About Access db and Forms
please visit this Link [^]

这篇关于Access DB中电子邮件字段的数据类型的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！