MS Access可以在您键入时将文本更改为所有CAPS吗?

问题描述:

我想在数据库中使用所有大写字母。无论键盘/大写锁定如何设置,我都希望显示所有类型的大写字母。我尝试使用点击事件格式化我的表单字段[CUST_LAST_NAME]?这是我尝试使用的代码(我在研究时在互联网上找到了这个代码)。

I want to use all caps in a database. I desire to show all caps AS YOU TYPE regardless of how the keyboard/caps lock is set. I tried to format my form field [CUST_LAST_NAME] with an on-click event?and this is the code I am trying to use (which I found on the internet while researching this).

展开 | 选择 | Wrap | Line数字

DanicaDear,

您可以使用输入掩码,例如> aaaaa和在文本框输入掩码中属性。您需要继续上面的a'以包含允许用户输入的任意数量的字符。


~JennDub
DanicaDear,
You could use an input mask such as ">aaaaa" in the text box "Input Mask" property. You would need to continue the a''s above for as many characters as you would like to allow the user to enter.

~JennDub


输入掩码要求他们以某种方式输入信息(即按下大写锁定键)。我不希望他们这样做。我知道这只是按键......不是那么困难......但我正在设计一个程序以匹配他们目前使用的程序,我希望条目完全相同。目前,无论他们如何键入信息,它都会显示并存储为大写字母。感谢JennDub的回复。还有什么建议吗?
The input mask requires that they enter info a certain way (ie. press the caps lock key). I don''t want them to have to do that. I know it''s just pressing a key...not that difficult....but I''m designing a program to match what they currently use and I want the entry to be the exact same. Currently, it doesn''t matter how they type in the info, it appears and stores as caps. Thanks JennDub for your reply. Any more suggestions?


DanicaDear,


JennDub建议做什么,输入掩码大写所有键击,没有必要按Caps Lock键。输入掩码不是验证工具,它是一个掩码。


-AJ
DanicaDear,

What JennDub suggests does work, the input mask upper cases all key strokes, there is no need to hit the Caps Lock key. Input mask is not a validation tool, it''s a mask.

-AJ