Format Reports

[M8KWR]

What i require is when a field (text0) within my report is a certain value lets say either IsNull or equal to 1 then i want to alter the text and field displayed in another text box, lets call that Text1

I know you can alter the background colours etc, but i can not seem to find a way to alter the text in each record in the report.

Any help would be appreciated.

 

[ColinEssex]

Just thinking quickly. . . Can't you do this in the query with an IIf statement?

or

in the Conditional Formatting of the report?

Col