Access - Field size for numerical field?
With text boxes, you can set field size on how many characters can be entered. Is it possible to do this to a numerical field?
You could use the format property. Another option would be to treat the field as a text box and the format property. Then when you want to use the value numerically use the val function.
No. What you can do is to apply a validation rule to your number field in the table. Like:
Len([enter your field name here])<=4
Plus a validation message:
Number should be 4 digits at most
There's other option too like applying a Before Update event in your form that you use to maintain the data.
And another possible option might be to apply a data macro. Can't help you on that one as my Access version is pretty old.