Z
zmenloans
I realize that there is no way to individually color a record in a table, so
I created a form with Conditional Formatting to change the background color
of the record in the form based on certain choices. However, Conditional
Formatting only allows you to choose three conditions, and I have ten.
The column is a drop-down list with the ten choices, and I want the form to
have a different color in the field for each choice. For example, if the
field choice was "Paying", I would like the field green. "Out for Repo" =
Orange, "Restructure" = purple, "Follow-Up" = gray, and so on.
Is there some sort of code I can use on the form for this? I am pretty new
to Access so I'd appreciate any help I can get. Also, if there is a sort of
code, can you tell me exactly where to put the code, because I don't know my
way around so well.
Thanks
I created a form with Conditional Formatting to change the background color
of the record in the form based on certain choices. However, Conditional
Formatting only allows you to choose three conditions, and I have ten.
The column is a drop-down list with the ten choices, and I want the form to
have a different color in the field for each choice. For example, if the
field choice was "Paying", I would like the field green. "Out for Repo" =
Orange, "Restructure" = purple, "Follow-Up" = gray, and so on.
Is there some sort of code I can use on the form for this? I am pretty new
to Access so I'd appreciate any help I can get. Also, if there is a sort of
code, can you tell me exactly where to put the code, because I don't know my
way around so well.
Thanks