I have an if statement that pulls a value in a field, where it uses a replace statement to replace &'s with blanks. Now, here is the kicker. If the value is "other" then I want to replace "other" with the string in a box that explains what other is.

If not isnull (thisfield) then
replace (thisfield),"&"," ") but if (thisfield) = "other" then still replace "&" with " " but also replace "other" with "this is the other value."