Hi there,
Am I right in presuming that the zeroes on the front are purely for display purposes, so that when you view or print your data, the number is always displayed with zeroes on the front for numbers less than 10 digits long?
Can I also take it that your field is currently of data type "Text" and not "Number"?
If yes to both, then I strongly suggest converting your field to "Number". Then in the field property "Format", type in ten zeroes. If you have any forms or reports which already use this field, also change the "Format" property to be ten zeroes.
Good luck... Richard
This may be a simple matter but for some reason I just cant figure it out. I have a field in access that I want to keep as text, but the contents of the field is numbers. I want every entry to be 10 digits. If the contents are less than 10 digits I want to have zeros padding the front. Is there an easy way to do this?

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic