Changing font color in one section when value = true in a differen

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Changing font color in one section when value = true in a different section.

I'm trying to make a section of font (Company Name) Red/Bold when value =
true (Recommended = "No") in a different section.

I've done searches on this but all that returns is how to do this in the
same section. I'm not sure how to write the code. Help?!

Thanks!
 
You would use conditional formatting in the Company Name field. Change the
first drop-down to "Expression Is" then enter your expression in the next
field. Then set the color and bold options.

See the help fiel if you need further assistance.

Rick B
 
I've tried that & it didn't work. I think that doesn't work because I'm
wanting to change font in one section when a value = true in a *different*
section. I've tried writing the code in VB in the Format event procedure of
the report's detail section. Yet I can't get it to work. Here is an example
of my report. I hope this makes sense. Thanks!

Company Name (Red/Bold Font) Company Name
Recommended = No (Hide) Recommended = Yes (Hide)

I would like to hide the Recommended section at all times. Yet when
Recommended is = No, I want the company name to be in red/bold.
 
I got it to work! I didn't write the VB code for it though. I used the
conditional formatting option like you suggested except this time I put the
Recommended in brackets. This worked! Thanks for your help!!!

Would writing it VB be more stable or have any other advantages? I'm just
curious. I"ll be loading the DB onto a SQL server. Not sure if that would
matter or not.

Thanks again!
 
You keep saying "section" What do you mean? A section is the detail
section, the group heading, etc. A control or a field is what the
individual objects (like Company name) would be called.

Conditional formatting will let you evaluate an EXPRESSION which could be
anything. Does not have to apply to the current control. Did you change
the first drop-down to "expression is" liek I stated? Then fif you enter a
formula such as...

Recommended="no"


Is Recommended a yes/no field?
 
Back
Top