Conditional Formatting

[mm07nkb]

Hi,

I have an unbound textbox that I want to apply conditional formatting to.

I have a listbox and when certain rows are highlighted in the listbox I want my unbound textbox to turn grey scale.

My listbox is sourced from a seperate table.



Any help would be greatly appreciated!!

Im on Access 2007

Thanks

[rpeare]

go to your unbound text box, click on the conditional formatting

In the first box put EXPRESSION IS
in the second box put
[ListBoxName] = "TextValue"
or
in the second box put
[ListBoxName] = NumberValue

where listbox name is the name of your list box and textvalue is the value of the text OR numbervalue (no " marks) if it's a numeric value.

set your conditional formatting values (back ground color)

Note this will only work if you are using the bound column of the list box