Appreciate your help. I'm sure this is something really simple, that I'm missing, but now I'm getting an error message that "a boolean is required". If I remove the or condition, it tells me I'm missing a parenthesis ")" By the way I forgot to mention that EMPLOYEE.EMPLOYEE is a numeric field that I'm converting to text. Thanks.
space(15) + (
if len(Cstr(ToNumber({EMPLOYEE.EMPLOYEE})))=3 then "000000000000" + totext({EMPLOYEE.EMPLOYEE})
OR
if len(Cstr(ToNumber({EMPLOYEE.EMPLOYEE})))=4 then "00000000000" + totext({EMPLOYEE.EMPLOYEE})
OR
if len(Cstr(ToNumber({EMPLOYEE.EMPLOYEE})))=5 then "0000000000" + totext({EMPLOYEE.EMPLOYEE})
OR
if len(Cstr(ToNumber({EMPLOYEE.EMPLOYEE})))=6 then "000000000" + totext({EMPLOYEE.EMPLOYEE})
OR
if len(Cstr(ToNumber({EMPLOYEE.EMPLOYEE})))=7 then "00000000" + totext({EMPLOYEE.EMPLOYEE})
if len(Cstr(ToNumber({EMPLOYEE.EMPLOYEE})))=8 then "0000000" + totext({EMPLOYEE.EMPLOYEE})
OR
if len(Cstr(ToNumber({EMPLOYEE.EMPLOYEE})))=9 then "000000" + totext({EMPLOYEE.EMPLOYEE})
)