Forms

[Guest]

This question is about Forms,
There is an ID field which is self incrementing field where the first umber is 0, the next one will automatically be 1, then 2, and so on.
I am requested that numbers between 0 and 9 have two zeros in front of them (eg 001 or 002) and numbers from 10 to 99 have one zero in front of them (eg 034 or 056).
How can I achieve this? By default when entering a number Access wont put any zeros in front of any integers.

Any help in finding the solution for this will be greatly appreciated.

Best regards,

Lucas

 

[Rick Brandt]

This question is about Forms,
There is an ID field which is self incrementing field where the first

umber is 0, the next one will automatically be 1, then 2, and so on.

I am requested that numbers between 0 and 9 have two zeros in front of

them (eg 001 or 002) and numbers from 10 to 99 have one zero in front of
them (eg 034 or 056).

How can I achieve this? By default when entering a number Access wont put

any zeros in front of any integers.

Any help in finding the solution for this will be greatly appreciated.

Just use a format property of "000". This will *display* leading zeros.
The only way to *store* leading zeros is in a text field.