hi,
Just wondering if there is a way to do this in the conditional formatting box.
I have a textbox (txt1) in my report that has the following control source:
= [field1] & " / " & [field2]
which pretty much shows:
1 / 2
3 / 3
etc.
How can I set the conditional formatting so that if field1 = field 2 it will highlight the entire text box (txt1)?
thanks!
j
Just wondering if there is a way to do this in the conditional formatting box.
I have a textbox (txt1) in my report that has the following control source:
= [field1] & " / " & [field2]
which pretty much shows:
1 / 2
3 / 3
etc.
How can I set the conditional formatting so that if field1 = field 2 it will highlight the entire text box (txt1)?
thanks!
j