conditional formatting

[Werner62]

Hi, how can I change the color of a Field in a row of a "ds" with "Conditional format" when it concerns a "CheckBox".Example: Field1: "ID No" Becomes Green When Field2: "CheckBox" is "activated"
Many Thanks. Werner

[RuralGuy]

What have you tried so far?

[isladogs]

In design view, select the field you want to format [ID no] and select Conditional Formatting
Select New Rule and change the dropdown to Expression Is

You then need to type the field name (NOT the control name) in square brackets and the condition.
So if the field name is Field2 and it's a text field with 'Activated' as the value

Expression Is [Field2]="Activated"

If it's a boolean (Yes/No) field then

Expression Is [Field2]=True

[Werner62]

Thank you ridders52 Short clear and it works.Thx. W.