Zeros in Access field number

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
:confused:

try changing data type of the ID Field to text !

Thanks for helping me out. So as far as formating the field as number, there is no option in Access?

Again, thanks. I'll try as text if there is no other option.

Chong

Sure . you can't store like this value in the database unless you convert it into text . I can't see any problems here . you can easily convert it into interger when you need to or vice versa throgh one line of code ;)

Thanks!

Chong