I have two text boxes on a report. One is bound to a field in a table.
The other has a formula that combines the values from two other table
fields.

If there is a particular value in the bound field, I want the unbound
text box to display a particular text string, instead of the string
that it now displays as a result of the formula.

How do I do that? Thanks.