Replacing the Numbers

[Guest]

In my report I want to replace the value of my text data to a word.

Example: in my report the TextBox: is (loc) which the "1", "2", "3" these
are the records in the tables. They print out on the reports as 1, 2, and 3.
I want to change that to read 1=ED, 2=EU and 3=EZ. And blank, if the user
leave it blank as "NONE"

I hope that's clear

Thanks

 

[Duane Hookom]

Check out your more recent thread with the same question.