UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Conditional Format, Access 2016    
 
   
mike60smart
post Aug 30 2019, 11:42 AM
Post#1


UtterAccess VIP
Posts: 13,469
Joined: 6-June 05
From: Dunbar,Scotland


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

--------------------
Hope this helps?

Mike

Get happiness out of your work or you may never know what happiness is.

Go to the top of the page
 
arnelgp
post Aug 30 2019, 11:47 AM
Post#2



Posts: 1,510
Joined: 2-April 09
From: somewhere out there...


Expression Is: [FieldName] = "Not Applicable"

--------------------
Never stop learning, because life never stops teaching.
Go to the top of the page
 
theDBguy
post Aug 30 2019, 11:47 AM
Post#3


Access Wiki and Forums Moderator
Posts: 76,522
Joined: 19-June 07
From: SunnySandyEggo


Hi Mike. Have you tried something like?
CODE
Expression Is: [FieldName] Like "*Not Applicable*"

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
mike60smart
post Aug 30 2019, 12:16 PM
Post#4


UtterAccess VIP
Posts: 13,469
Joined: 6-June 05
From: Dunbar,Scotland


Hi theDBGuy

That works a treat

Many thanks yet again

cheers.gif

--------------------
Hope this helps?

Mike

Get happiness out of your work or you may never know what happiness is.

Go to the top of the page
 
theDBguy
post Aug 30 2019, 12:24 PM
Post#5


Access Wiki and Forums Moderator
Posts: 76,522
Joined: 19-June 07
From: SunnySandyEggo


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

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    14th November 2019 - 12:15 PM