Access 2016中的输入掩码和验证规则 [英] Input Masks and Validtion Rules in Access 2016
问题描述
我正在尝试为业务联系人列表构建Access数据库。我需要在Form中知道我应该用于类别"Hot","Warm"和"Cold"的格式。使用输入掩码的联系人。在表格内部,我希望用户可以只需输入"H"即可获得
。或"h"或"h"。对于热,"W"或"w"对于暖和"C"或"c"或"c"。对于冷接触,或者他们可以简单地说出热,暖或冷。我想我可能需要一个验证
代码或其他东西,所以它只需要H / W / C.我不知道如何使用输入掩码或其他用途。
I'm trying to build an Access Database for a Business contact list. I need to know inside the Form the format I should use for the Categories "Hot", "Warm", and "Cold" Contacts using an Input Mask. Inside the Form I would like
the User to just be able to put in "H" or "h" for Hot, "W" or "w" for Warm and "C" or "c" for Cold Contacts, or they could just put in the whole words Hot, Warm or Cold. I think I may need a Validation
code or something so it will only take the H/W/C. I do not know how to use an Input Mask or what else to use for this.
我还想知道如何添加一个复选框访问中的表单。
I also want to know how to add a Check Box in a Form in Access.
Thanx串联GVHSE
Thanx bunches GVHSE
推荐答案
为了更好地解决问题,我将把线程移到Access论坛以获得更多帮助。
To better fix the issue, I will move the thread to Access forum for more help.
我们推荐的原因如果发布得当,您将获得最合格的受访者群体,而定期阅读论坛的其他合作伙伴可以分享他们的知识或从您与我们的互动中学习。感谢您的理解。
The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.
这篇关于Access 2016中的输入掩码和验证规则的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!