Inserting zeros into a text field

[Ron]

Hi,

I have a text field with the length of 10, and would like
to "pad" the field with zeros if there is not a character
present.

For Example, if my field has 123 in it, I would like to
change it to 0000000123. If the field has 99999 in it, I
would like it to be changed to 0000099999.

Thanks.

 

[Fredg]

Ron,

Exp: String(10-Len([FieldName]),"0") & [FieldName]