CODEWITHSUNDEEP
databaseformsms-accessconditional-formattingms-access-2016
Seb
Seb

Reputation: 520

Apply conditional formatting depending on an other field's value

On the field DaysSinceRequest of an an Access' Form, I am applying a conditional formatting depending on its value in eavch record, that part is fine.

But how could I tell "Apply the conditional formatting to the field DaysSinceRequest ONLY if the field DatePartReceived is empty/null" ?

Is there a way to do this ?

PS : Just to show that I've done something before haters start down rating, here are the rules I've applied to the field DaysSinceRequest and the result in the Datasheet View

Tell if if my post is not clear enough, thanks

Upvotes: 0

Views: 291

Answers (1)

Sergey S.
Sergey S.

Reputation: 6336

Just use Expression Is instead of Field Value Is and in Expression field you can use any expression, which evaluates to Boolean value. In your case you can use IsNull function

Upvotes: 1

Related Questions