I have a customer number field that needs the leading zeros put back into the field.
Is there a way?

Format Property 000000000 ?

The Format property does not actually store leading zeros, it only shows them. You will probably need to use the Format property or Format() function every time you want to show the customer number field. Use as many zeros as you need to make the field the length you want. If you want it to always show 7 characters, use 7 zeros.