Force leading zeros in front of a number 2

[tdrBates]

How can we force a number to always be 4 digits in length?
We're trying to pad a number with leading zeros. Is there a function in MS Access that can do this?

Example: "0008" or "0011"

Thanks

 

[SgtJarrow]

in the format property for the field....put four 0000's. Only two things are infinite, the universe and human stupidity, and I'm not sure about the former. (Albert Einstein)

Robert L. Johnson III, MCP, Network+, A+
Access Developer/Programmer
robert.l.johnson.iii@citigroup.com

 

[jebry]

Hi!

Robert's way is easiest but the function in Access to do this is Format(yournumber, "0000&quot

hth
Jeff Bridgham
bridgham@purdue.edu

 

[SgtJarrow]

thanks jebry....forgot to mention that! Only two things are infinite, the universe and human stupidity, and I'm not sure about the former. (Albert Einstein)

Robert L. Johnson III, MCP, Network+, A+
Access Developer/Programmer
robert.l.johnson.iii@citigroup.com

 

[jebry]

Hi Robert!

Well, if I deserved a star for my post, yours is certainly worthy as well!


Jeff Bridgham
bridgham@purdue.edu

 

[SgtJarrow]

jebry,
of course you deserved the star...you provided a good, simple solution to the poster's question....and by giving you the star, someone else will hopefully find the post and use it for their question.... Only two things are infinite, the universe and human stupidity, and I'm not sure about the former. (Albert Einstein)

Robert L. Johnson III, MCP, Network+, A+
Access Developer/Programmer
robert.l.johnson.iii@citigroup.com