Changing Colors on Continuous Form

  • Thread starter Thread starter Cathy
  • Start date Start date
C

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?
 
Cathy said:
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?
Click to expand...


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)
 
You are awesome! It works perfectly!

Thank you very much.

Cathy

Marshall Barton said:
Cathy said:
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?
Click to expand...


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)
Click to expand...
 
Back
Top