Conditional Formatting - And Operator

[tinaajith]

Hi all,

I have a field in my form which returns all the order id.

I want to display all the order ID in purple color based on this condition --> [Order.Active]=0
And for the same order ID i want to display Green color for Condition 2 --> [paid date] is not null.
The above works fine..

I want to have a thrid condition -- when both the condition is true, all the order ID's should get displayed Orange...
I tried the following way:

Condition 3
Expression IS [order.Active]=0 And [Paid date] is not null
Andf the color i seleced "Orange"

But when in form view, Condition 3 is not checked.

Has anyone used "And" operator in setting a condition. Or is there any other way to acheive this? Or my syntax is worng? Please help.

Thanks in advance.

 

[llkhoutx]

Generate what you want on the Oncurrent event.