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?

2 answers

  • answered 2017-11-15 01:22 Charles_D

    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.

  • answered 2017-11-15 04:58 Rene

    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.