Conditional formatting

  • Thread starter Thread starter hermie
  • Start date Start date
H

hermie

On my report i did a conditional format on 1 field
like: Field Value = equal to "F" textcolor RED
This works, however not all fields which have an F are shown in red some
have some not??

What can cause this problem?

Herman
 
Is it possible that there is something else in these fields as well as an F.
For example, a leading space? You could see that fairly easily if you create
a query into the table that holds this field, and sort on the field. The
spaces would sort to the top.

If that is not the issue, and the field is indexed, it could be a corrupted
index. If so, that should be fixed with a compact repair:
Tools | Database Utilities | Compact/repair
 
Allen
For your information
I found the problem. I have 2 conditional formats
first is an expression ([txtCount] Mod 2 = 0 for all fields in detail
section, second conditional format is a format on 1 field where the field
Value is equal to "F"color Red
When I remove the expression condition from the field which have also the
Value condition then it shows all in color.
Access not accept 2 conditions in 1 field?

Herman
 
Back
Top