conditional formatting - string contents

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way, on a record by record basis, that I could check if the value
in a text box within a report contains a particular search string and if so,
the text box would be formatted in a particular way?
 
Thanks for the quick reply

How would I check for the word "missing" in the value of a text box (which
can contain a full sentence) for each record and then format the text red for
instance?
 
Select the text box and then menu: Format->Conditional Formatting. You can
set the Expression Is to something like:
=Instr([YourFieldName],"missing")>0
 
Back
Top