I get the same result: junk i.e. IF(2E...
Strange, huh? It doesn't appear that you can use an IIF() in the format of a field on a report? Yet I could swear that I remember doing this in the past.

Tracy

>I'd use...
>
>

>iif(len(alltrim(po_zip))>5,transform(po_zip,"@R 99999-9999"),left(po_zip,5))
>

>
>Of course this is assuming that your zipcode with either 5 characters or 9 characters (ie your "-" is never stored in the zipcode).
>
>>I am trying to display zip codes using the following in the format of the field box:
>>
>>

>>IIF(LEN(ALLTRIM(PO_ZIP))>5,@R 99999-9999,99999)
>>

>>
>>It does not work obviously. Is there anyway to do this? I do not want something like: 28314- when the zip code is not 9 digits. Yet I want the dash if it is 9 nine digits. Any ideas? TIA,
>>Tracy