Any one know a way to format the MS Access field to have zeros in front of a number, let's say 1? I want to have a format like 00001 00002 00003 in the field number for ID. Whenever I put a zero in front of number, the zero disappeared. I want to put zeros in front of a number so when I truncate the texts from the ID number in my VB .NET application, it's easier for me to do it.

Many thanks in advance!

Chong