Can I apply input mask to a numeric field ?

[Peter]

There is a requirement to enter YYYY in a number field.

I have assigned a Integer field for this purpose. I would like to know is
it possible to apply input mask so that end user will enter only 4 digits
only ?

Thanks

 

[Arvin Meyer [MVP]]

If you want exactly 4 digits, use:

0000

If you want up to 4 digits, use:

9999

 

[Peter]

Dear Arvin,

Thank you for your advice.

Initially, I apply input mask on the table but it doesn't work. Then I
apply input mask on the form that end user will enter data.

I would like to know why we have to apply the input mask in the form level
but not in the table level ?

Thanks
Peter

 

[Arvin Meyer [MVP]]

Input masks are enforced at the table level regardless of how you enter
data. If you use a form, it is handy to also put the mask on the textbox in
the form to avoid having to wait until the record is committed before
finding out that the data won't work.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com