Microsoft Access Conditional Formatting regarding drop down lists

Question

Hi, 

I am trying to have an entire row become highlighted in a certain color when a certain field in a form from a drop down list is selected. For example, I have a form which states many things such as name, date, status of completion. Status of completion has a drop down list which contains completed, incomplete, n/a. What I would like to do is when "incomplete" is selected, the corresponding row in the corresponding table turns red. Is there any way to do this? Any suggestions would be helpful.

Answer 1

Conditional Formatting should do it. What I would do is create a box control that covers the whole row. Then move it all the way to the back. Then use Conditional formatting to change the Back color of the box based on the value in the combobox.

Answer 2

Would you happen to know what function I can use for the conditional formatting for a drop down list? I have looked everywhere but haven't found anything specifically for my issue.

Answer 3

Thanks so much!