Chong Posted April 15, 2003 Posted April 15, 2003 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 Quote
Moderators Robby Posted April 15, 2003 Moderators Posted April 15, 2003 No, the only way to hold leading zeros in a field is to set the data type to string (text). Quote Visit...Bassic Software
Chong Posted April 15, 2003 Author Posted April 15, 2003 Thank you very much for helping me out. I thought is a way. However, your suggestion will work too. Chong Quote
*Gurus* Derek Stone Posted April 15, 2003 *Gurus* Posted April 15, 2003 Set the field property Format to "0000000" (without the quotes). Quote Posting Guidelines
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.