Using Access 2002, I want to compare the data in table1 to the data in table2 as part of a form's conditional formatting expression. These two tables have identical structures. I thought that the "Me" self-reference could help with this, but perhaps my syntax is not right, or this is not do-able with conditional formatting.
My conditional formatting expression for a text box should be something like:
[table1.field1]=[table2.field1]
However, I want this rule to work for many (if not all) fields. Since each text box has a defined ControlSource property, I thought that I could use the same expression for each field I chose to use on the form as follows:
[table1.(Me.ControlSource)]=[table2.(Me.ControlSource)]
Any ideas to make this work?
Thanks in advance.
My conditional formatting expression for a text box should be something like:
[table1.field1]=[table2.field1]
However, I want this rule to work for many (if not all) fields. Since each text box has a defined ControlSource property, I thought that I could use the same expression for each field I chose to use on the form as follows:
[table1.(Me.ControlSource)]=[table2.(Me.ControlSource)]
Any ideas to make this work?
Thanks in advance.