Trimming

  • Thread starter Thread starter nl
  • Start date Start date
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.
 
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
 
Back
Top