highligth specific records

[Sara Fayez]

Hello:
i have a report that has a column with company names and another one
with fees i want when company name =a certain name the controls i have
be highlight in a a specific color pleas if this done with vb code
please sent me the code cause i don't know VB

 

[Marshall Barton]

i have a report that has a column with company names and another one
with fees i want when company name =a certain name the controls i have
be highlight in a a specific color pleas if this done with vb code
please sent me the code cause i don't know VB

You should be able to use Conditional Formatting to do this
without any code. Select the control you want to highlight,
then use the Format - Conditional Formatting menu item. Use
the Expression Is: option and set the expression to
something like:
[name of company textbox] = "a certain name"
then choose the hightlighting color in the fore or back
color properties.

For a more robust approach to this kind of thing, you should
add a column (field) to the appropriate table. This can
then be used to indicate if the data should be highlighted
with out making the report dependent on a particular
company's name (and how it's spelled this year).