Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Conditional Formatting on 2 values

Status
Not open for further replies.

cutestuff

Technical User
Sep 7, 2006
162
CA
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
 
Never mind. I figured it out :). I guess I didn't see the "expression is" selection. How can I delete this post? Is that possible?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top