Condition Formatting, Change Color Of Text If Values Are Different

[LindaOSU]

We have a table that is updated monthly from a CD. I already have a report that pulls only certain fields from the changed records. There are 5 fields that have a Pre and a Post we want to compare. Pre1 to Post1, Pre2 to Post2 up to Pre5-Post5. Within a single record, any of these pairs maybe be updated. So, for example, a record could have:

Pre1: 1030
Post1: 1030
Pre2: LamoTRIGine
Post2: lamoTRIgine
Pre3: YES
Post3: NO
Pre4: null
Post4: Penicillin
Pre5: YES
Post5: YES

For this record, pre2-post2, pre3-post3, pre4-post4 would be considered "changed". I would like these fields to have red text in the report. Is there a case statement that would work? The capitalization (Tallman lettering) is important also. I have the query that pulls out the Tallman lettering changes but can these changes be printed in red also? I want only the changed pair(s) to be in red, not the whole record. All these are Text fields, no Numbers or Dates.

Thank you.
LindaOSU

[pbaldy]

As answered elsewhere:

Generally speaking this should be fairly easy. In Conditional Formatting, using Expression Is, a test like

[Pre1] <> [Post1]

should work. The tricky part is the case bit, but check out StrComp() in help and see if it works for you.