I think it doesn't work, because I am allowing multiple values be chosen in my drop down list...could that be, and is there and expression that would account for that? i.e. If multiple choices are made, that if one of them is Other, than the Other field is highlighted?
:banghead:Yes I typed it correctly. I have played around with it and if it's not part of a list then it works.........???? I am assuming that my expression is wrong.
Unfortunately I cannot post the DB. I'll explain again and maybe you can show me the expression I should use. I created a combobox through the lookup wizard when creating my table. It has 12 values in it. The last one is "Other". In the related form, I want the text box of the field...
I'm trying to make a field become highlighted if a certain item is picked from a drop down list. For example if Other is chosen, another field named Other? becomes highlighted. I have tried it in conditional formatting, using Expression is [Field Name] = "Other" but it doesn't work when I...