Well this is an Access database forum; however, since Access has the same
behavior, I'll take a stab:
Numbers don't have leading zeros.
If you need to see leading zeros, format it as a text field.
In Access there are some fancy ways to display leading zeros in front of
numerical characters, but then it's no longer a number.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.