Trimming

N

nl

In a report, if a field contains a value of "o,o", how can
I make the text box to show the other criteria, but to
trim it when it shows "o,o"???

thank you.
 
H

hcj

Hi,
If by your question you mean display all values except
when val="o,o", try this:
Instead of using the field itself on the report,
substitue a bound text box containing the expression
=iif(val="o,o","",val)

Good luck. hcj
 
Top