form field background color conditional on another field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want the background color of field last_name to change to gray if the value
of the field deceased? is true
 
I want the background color of field last_name to change to gray if the value
of the field deceased? is true
Click to expand...

In Form Design View, select the [last_Name] control.
Then click on Format + Conditional Formatting

Set Condition1 to:
Expression Is
Then write:
[Deceased] = True
in the next box.
Set the color to gray.
Save the changes.
 
Back
Top