Text box format in a Report

L

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
 
K

KARL DEWEY

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

No text box in word 2016 0
How to getting text labels to show up in scatter chart. 0
Creating a Search using a combo box and then creating a report. 4
Clearing combo boxes and a text box 2
Link a text box based on drop down box with four options MS Word 365 0
Schedule Comparison Error - mismatch duration - "The duration you entered isn't supported for this field. type a duration in the standard format" 0
MS Word normal.dot cannot be fixed 'text box' appears each time 4
Word OLE to check spelling in text box 1

Top