change data color based on field in table

  • Thread starter Thread starter Eugene
  • Start date Start date
E

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.
 
Eugene said:
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.
Click to expand...


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.
 
Back
Top