I would like to format an amount field with leading zeros and remove the decimal but keep the 2 digit cents. I would also like to have trailing spaces for a text field. Does anyone know how to accomplish this? I've tried several things like right('0000000000' + [Amount],12).