Left fill blank spaces in field with zeros 1

[srossbach]

I have a text field in my table that is 4 characters in length - each record is a number but may only be 2 or 3 characters....

92
143
and I need to return a value that fills all 4 characters...

0092
0143

Can this be done?

Thanks for your help! And Happy Holidays!

 

[braindead2]

right("00" & [yourfiledname),4)

 

[jebry]

Hi!

Try Format(YourFieldName, "0000&quot

hth Jeff Bridgham
bridgham@purdue.edu