Restrict "number" field to 6 digits |Access 2013

[oriels]

Hi
How can i restrict a field of type "number" to 6 digitis at the most? i need it with leading zeros.
Thank You .!

[orange]

Can you tell readers why this particular format is needed?
Numbers don't normally have leading zeros. You can put a format(yourNumber) but it will result in a string data type.

[June7]

A number type field will not retain leading zeros. You can format a number to display leading zeros but will not be stored.

You can try an Input Mask as well as Validation Rule.

[oriels]

ID, but i was demanded for a number type.

I made design template and set it to "000000" I also make validation rule to <999999 so it work fine.
there is any way to make it with a better way?

Another problem that I noticed is when i put ######.# it makes it good so I see "######" but if I want to restrict for just exact 6 digits without allow "." (dot). does it possible?
Thank you a lot!!!

A number type field will not retain leading zeros. You can format a number to display leading zeros but will not be stored.

You can try an Input Mask as well as Validation Rule.

Input Mask are not allowed in number type.

[June7]

The field type should be set as Integer or Long Integer to prevent decimal.

Can use VBA behind the textbox to do validation. The BeforeUpdate event is commonly used for this.