Using Conditional formatting to compare two strings....

[s.vanderford]

I have a report in access database that I am using conditional
formating for. I am comparing two values, a new value and an old
value. Both are text. When the new value differs from the old value,
I want the new value to have a text of red. However, if it doesn't
differ, I want it to remain black. My conditional formatting reads :

Condition 1
Field Value is not equal to "OldExpVelocity" and has the text turning
to bold and changing to red.

Now, I have used this logic in other reports and it works. However, in
this situation it is showing every new item as changed. I checked when
it is pointing back to and the source is correct. is there something I
am missing?

 

[Guest]

You need to change "OldExpVelocity" to [OldExpVelocity]

 

[Azzna]

You are awesome! I have been racking my brain on this for about 2 days
(on and off) and I am so glad I decided to post here and VERY VERY glad
you responded. Thanks!

You need to change "OldExpVelocity" to [OldExpVelocity]
--
Duane Hookom
Microsoft Access MVP

I have a report in access database that I am using conditional
formating for. I am comparing two values, a new value and an old
value. Both are text. When the new value differs from the old value,
I want the new value to have a text of red. However, if it doesn't
differ, I want it to remain black. My conditional formatting reads :

Condition 1
Field Value is not equal to "OldExpVelocity" and has the text turning
to bold and changing to red.

Now, I have used this logic in other reports and it works. However, in
this situation it is showing every new item as changed. I checked when
it is pointing back to and the source is correct. is there something I
am missing?