Conditional formatting

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

Guest

I'm using Access 2002. In my report, I would like a field "B" to be bold and
red if it's less than the goal amount in field "A". I tried conditional
formatting, but it's changing the field regardless if the # is < or >. Do I
need to use VBA code? If so, please dummy it down for me. I know very
little about code, so I won't be insulted.

Thank you.
 
I'm using Access 2002. In my report, I would like a field "B" to be bold and
red if it's less than the goal amount in field "A". I tried conditional
formatting, but it's changing the field regardless if the # is < or >. Do I
need to use VBA code? If so, please dummy it down for me. I know very
little about code, so I won't be insulted.

Thank you.
Click to expand...

It would have helped had you posted the actual expression you used, as
Conditional Formatting, with the proper expression, should have
worked.

Click on the ControlB.
Click on Format + Conditional Formatting.
Click on the Condition1 dropdown.
Select
Field Value Is.
In the next box select
Less than.
In the next box write:
[ControlA]
Select Bold and Red for the backcolor.

The above works for me.
 
Back
Top