Conditional Formatting

[Guest]

Hi,

In a report I am having trouble with conditional formatting. I have a text
box that gives a number. If the number is above 45 I need it to be bold and
the background color to be changed. I have tried conditional formatting. If
the first record on the report is > 45, it highlights that record but no
other record that is >45. If the first record is not greater than 45 it does
not highlight anything.

Any thoughs or suggestions would be appreciated.

Thanks Guys!!!

Amy

 

[Wayne Morgan]

You say that you've tried Conditional Formatting, but not what you've done
to "try it".

Right click the control in report design view and choose Conditional
Formatting. In the first drop down choose "Field Value Is". In the second
drop down choose "greater than". In the textbox to the right of the second
drop down type 45. Select Bold and your background color choice.

What is the data type of the field that the textbox is bound to, text or
number? I know it contains a number, but what is the data type of the field
in the table.

Do you have any code in the section's Format event that may be overriding
the conditional formatting?