Changing Colors on Continuous Form

[Cathy]

I'm using Access 2007 and would like to compare two fields and change their
back color if they are not equal. The equation I need to use is
Left(field1,3) <> Left(field2,3). I don't believe this is something I can do
with Conditional Formatting, so how would I do this?

 

[Marshall Barton]

I'm using Access 2007 and would like to compare two fields and change their
back color if they are not equal. The equation I need to use is
Left(field1,3) <> Left(field2,3). I don't believe this is something I can do
with Conditional Formatting, so how would I do this?

CF can do that, but you need to use the Expression Is:
option. Even then, you (for some unknown reason) have to
enclose the field/control names in [ ]

Left([field1],3) <> Left([field2],3)

 

[Cathy]

You are awesome! It works perfectly!

Thank you very much.

Cathy

I'm using Access 2007 and would like to compare two fields and change their
back color if they are not equal. The equation I need to use is
Left(field1,3) <> Left(field2,3). I don't believe this is something I can do
with Conditional Formatting, so how would I do this?

CF can do that, but you need to use the Expression Is:
option. Even then, you (for some unknown reason) have to
enclose the field/control names in [ ]

Left([field1],3) <> Left([field2],3)