Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ Access Q and A _ Conditional Format

Posted by: mike60smart Aug 30 2019, 11:42 AM

Hi Everyone

I have Controls in a Continuous Forms that I need to highlight if they contain the text "Not Applicable"

What would the Expression be?

Any help appreciated

Posted by: arnelgp Aug 30 2019, 11:47 AM

Expression Is: [FieldName] = "Not Applicable"

Posted by: theDBguy Aug 30 2019, 11:47 AM

Hi Mike. Have you tried something like?

CODE
Expression Is: [FieldName] Like "*Not Applicable*"

Posted by: mike60smart Aug 30 2019, 12:16 PM

Hi theDBGuy

That works a treat

Many thanks yet again

cheers.gif

Posted by: theDBguy Aug 30 2019, 12:24 PM

Hi Mike. You're welcome. Arnel and I were happy to assist. Good luck with your project.