change data color based on field in table

[Eugene]

Let me explain, I have 2 tables on with transaction records and one with
users. The users contains id,first,last,yorn. this table is part of the
transaction record. What I want to do is if the yorn field is no, then the
dropdorn of the user name on the transaction for will be red, indicating not
to give an assignment to that user.

Can this be done relatively easily?

Thank you in advance.

 

[Marshall Barton]

Let me explain, I have 2 tables on with transaction records and one with
users. The users contains id,first,last,yorn. this table is part of the
transaction record. What I want to do is if the yorn field is no, then the
dropdorn of the user name on the transaction for will be red, indicating not
to give an assignment to that user.

You can use Condidtional Formatting on the name text boxes.

With the form open in design view, select the text box.
Then use the Format - Confitional Formatting menu item.
Select the Expression Is option in the drop list and then
enter an expression like:
[yorn] = "no"
If yorn is a Yes/No field (not a Text field) then its value
is really either True or False, in which case the expression
could be:
[yorn] =False

Then select the color red in the color picker.