Unanswered: Conditional Formatting for Detail Section 2010
I have a continuous form
Client wants to "flag" certain colors for the background (detail section) of each row based on a drop down color selection
meaning there is a combo box (bound) to a field called Color_Code
The drop down has 3 colors - Red , yellow, green.
based on the color selection I would like to invoke the conditional formatting that what ever the combo box says I would like the detail section to be that color
It's easy to use the conditional formatting for changing the formatting of one control based on that controls value or gotfocus - but I think I need to use the option "Is Expression" but I am missing something in the translation.
I am trying various versions of the following with no results:
if me.color_code= 'Red' then Me.Section(acDetail).Backcolor = vbRed