如何正确形成输入掩码？ [英] How do I Form the Input Mask Correctly

问题描述

大家好！

我在访问2010中有一个表，它包含一个包含短代码的列，它只需要6位数不小于6位且不大于6位必须修复6数字（例如123456）这是正确的，但是（例如1234567）不正确，


我不知道如何掩饰这个请尽快帮助我

hello all!
I have a table in access 2010 that it contains a column with a short code, and it required only 6 digits not less than and not more than 6 it must be fix 6 numbers (e.g 123456) this is correct, but (e.g 1234567) NOT correct,

I don''t know how to mask this please help Me as soon as possible

推荐答案

打开表格设计

选择字段

选择验证字段

按[ f1]


还
Allen Brown - 验证规则


我还会考虑在表单级别进行此类检查。

open the table design
select the field
select the validation field
press [f1]

also
Allen Brown - Validation Rules

I would also consider doing this kind of check at the form level.

您可以使用输入掩码控制。

选择你的字段并输入6次0

（0表示：y0u可以输入数字（0到9，需要输入，再加上[+]不允许使用减号[ - ]符号。

如Z所述：按F1可以看到更多选项。

You can do this using "Input Mask" control.
Select your field and enter 6 times "0"
(with 0 means : y0u can enter Digit (0 to 9, entry required, plus [+] and minus [–] signs not allowed).
As mentioned by Z: You can see more option pressing F1.

输入掩码您将使用的属性只是000000。不需要引号（"）。

The Input Mask property you would use for that would simply be "000000". Quotes (") not required.

这篇关于如何正确形成输入掩码？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！