Conditional Formatting Headache

  • Thread starter Thread starter Julius
  • Start date Start date
J

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.
 
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?
 
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.

Duane Hookom said:
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


Julius said:
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.
Click to expand...
Click to expand...
 
Back
Top