>>The cool trick I like to use for this kind of thing is to use the following in the field expression box:
>>

IIF(field=value,substitute_value,field)

>>HTH
>
> Yeah, that's what I'm doing in another one of my reports. Unfortunately, this field can be one of ten different values.

Ick. I have the same kind of thing on one report too. The way I andled it was with a UDF (Like Ed's reply) and use that insead of the IIF()