integer length

[teiben]

I have a field, integer, that needs to be exactly 6 characters long, no more, no less. How would I set this?

 

[Karma]

You can't. An integer is limited to a maximum positive value of 32767 which as you can see is only 5 digits long. If you use long integer you could use a validation rule in the table for that field >=100000 And <=999999 which defines the maximum and minimum positive 6 figure integers. Input masks only work for text or date fields.

HTH

K.