Conditional formatting issue
I have a fairly simple conditional formatting formula such that if Table A::field A's contents do not equal Table B::field A's contents, then turn the box red and the text yellow. The relationship between tables is a simple ID.
For reasons I cannot discern, in a couple of records, the conditional formatting is triggering EVEN WHEN the contents of both fields are exactly the same. I even cut and pasted the information into both fields so I would know that it is identical. And then I cut and pasted the shared simple ID that connects the two table.
Again, most of my records are working just fine.