Access 2007中的输入掩码帮助 [英] Input Mask help in Access 2007

问题描述

在数据表模式下的表格中输入数据时，我希望首字母的第一个字母自动大写，并自动将姓氏的第一个字母大写，并在名字和姓氏之间留一个空格。在设计模式下需要输入掩码的帮助。

When entering data in the table in datasheet mode I would like the first letter of first name to be automatically capitalized and also automatically capitalize the first letter of last name with a blank space between the first name and last name. Need help with the input mask in design mode.

推荐答案

这不能用输入掩码完成，输入掩码实际上是用于数字或日期输入。输入掩码不提供智能资本和字符串间距。


如果您希望继续这样做，您将不得不在相关控件的After Update事件中使用VBA代码采用编程方法。


-Stewart

This cannot be done with input masks, which are really intended for numeric or date input. Input masks do not provide intelligent capitalistion and spacing of strings.

If you wish to pursue this you would have to take a programmed approach using VBA code in the After Update event of the control concerned.

-Stewart

这比你需要的要复杂得多。 输入掩码可以处理字母等，但是如何为可变长度名称留出空间？一种更明智的方法是将两个名称存储在不同的字段中，并在需要时将它们显示为一个全名。

输入掩码帮助可以使用上下文相关帮助。您可以根据需要找到指定数据所需的全部内容。

This is a lot more complicated than you need. Input Masks can handle letters etc, but how would you allow space for variable-length names? A more sensible approach would be to store the two names in separate fields and simply display them as one full name when required.

Input Mask help can be found using Context-Sensitive Help. You will find there all you need to specify the data as you want it.

展开 | 选择 | Wrap | 行号

亲爱的先生NeoPa：


我同意你在两个单独的字段中存储名字和姓氏。然后使用组合文本值的表达式合并第三个字段中名为Full_Name的两个字段的值。


感谢您的帮助!!

Dear Mr. NeoPa:

I agree with you in storing the first name and last name in two separate fields. Then combine the values of two fields in third field called Full_Name using expression of combing text values.

Thank you for your help!!

这篇关于Access 2007中的输入掩码帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！