Conditional Formatting Headache

[Julius]

Good day, I have read 99% of all the post for conditional formatting and have
tried almost all of them and nothing works. Here is my very simle dilema.

[Text4] is my text box that is counts all the record numbers in my table
[Text1] simples stores a value

this is what I want: If [Text1] is not equal to [Text4] then bold,
highlight yellow and font color Red.

I have been using the Conditional formatting, I've tried expression and
value and nothing works. Can someone help me please. I am using 2003.

 

[Duane Hookom]

Did you try set the Expression Is to:
[Text4] <> [Text1]
Are these controls in the same section of the report? Did you make sure the
[]s are used?

 

[Julius]

thank u for your quick response, I figured it out, my numbers for whatever
reason were negative so its ok now, thank u and the conditional formatting
worked.

Did you try set the Expression Is to:
[Text4] <> [Text1]
Are these controls in the same section of the report? Did you make sure the
[]s are used?
--
Duane Hookom
Microsoft Access MVP

Good day, I have read 99% of all the post for conditional formatting and have
tried almost all of them and nothing works. Here is my very simle dilema.

[Text4] is my text box that is counts all the record numbers in my table
[Text1] simples stores a value

this is what I want: If [Text1] is not equal to [Text4] then bold,
highlight yellow and font color Red.

I have been using the Conditional formatting, I've tried expression and
value and nothing works. Can someone help me please. I am using 2003.