Text box format in a Report

[Lin]

Hi,

I have a text box in a report where I would like to change the number
format(%) depends on other text box value.
My report looks like the following
Item Jan Feb Mar...........
a 2 3 20
b .07 .25 .75

I would like the second row to be in % when the Item =b.How do I do that in
report.

Any help really appreciate.

Thanks

 

[KARL DEWEY]

Use an IIF statement --
=IIF([Item]="b", [FieldName]*100 & "%", [FieldName])