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?
 
You can use most types of expressions in the Conditional Formatting dialog.
 
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
 
You must log in or register to reply here.

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

CHECK BOX 1
Using a Calculated Control in a Report 2
Access 32bit vs 64bit subreport refresh issue 0
Converting GPS coordinates to decimal in Report 0
Conditional printing 1
Change text box background color depending on value in Label Reports 1
VBA: How can I use a string variable as autofilter criteria? 4
Set value of a text box conditionally 2

Back
Top