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
 

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

Back
Top