Condtional Format on a datasheet form with multiple criteria, boolean

[DutchKevin]

Hello,

I try to get this conditional formatting going on a datasheet form on which I display a query result. However it's not working properly with the OR criteria.
If Field1 equals 5 and the Description is un-equal to either textvalue, it should get a defined format.

Somehow it takes only the first check ito account, Field1=5
Can you suggest how this should work?

[Field1]=5 AND ([Description]<>"text1" OR [Description]<>"text2")

Thanks for Helping.

Kevin

 

[jackd]

You could try
[Field1]=5 AND NOT ([Description]= "text1" OR [Description] = "text2")

 

[DutchKevin]

Hello Jack
This seemed to work. I'm a bit puzzled why <> did not work. But never the less, I'm happy.

Thanks
Kevin

 

[jackd]

I think you are a victim of De Morgan's law.
De Morgan's laws - Wikipedia, the free encyclopedia

Glad it's working.

 

[strive4peace]

Hi Kevin,

you should be using AND not OR ... if 4 <> 3 or 4 <> 4 will be always be true

the method you posted should work if you use nz([Description],"") <> "Text1" AND nz([Description],"") = "text2"

if a value is blank, there is nothing to compare to. Null is NOT a value and cannot be compared to one.
NZ converts Null to a value so it CAN be compared. I usually specify the optional second argument although it is not necessary

btw, Description is a reserved word and should not be used for a name

Problem names and reserved words in Access by Allen Browne
Microsoft Access tips: Problem names and reserved words in Access

 

[DutchKevin]

Hello Chrystal,

I'm sorry i was not sooner in thanking you for your addition to the case.
So far i've not been able to get it working (also limited by the available three Conditional Formats in Access2007)
Due to holiday season I will cary this one over to next year and see if we can find new inspiration then

I wish everybody happy holidays !!

Best Regards
Kevin

 

[strive4peace]

you're welcome, Kevin

in Access 2010, you can add up to 50 conditional formatting rules for each object ... that could be inspiring