Format Report

[M8KWR]

What i require is when a field 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.

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.

 

[THWatson]

M8KWR
Have you tried putting code on the OnFormat event for the Detail section.

Something such as...
IIf([Field1]=<1,[TextBox]="other text","normal text")

If this doesn't work, you might have to change the expression...
IIf(IsNull([Field1]) Or [Field1]=1,[TextBox]="other text","normal text")

Tom