Need help w/conditional format of text box on form

[John]

Hi - Although I have looked through several conditional formating
posts, I have not seen any that have helped with this problem. I have
a continuous form that shows Index, txtA and txtB for several Index
values. On each row, I want to set the background of txtB to grey if
it does not equal txtA. Thanks for any help.

 

[Fredg]

I'm assuming you have Conditional Formatting on your version of Access.
Click on the txtB control.
Click Format + Conditional Formatting
Set the Condition 1 drop-down box to:
Expression Is
In the Text box alongside this drop-down, write:
[txtB] <> [txtA]
Select the color, etc. for this condition.
Exit.

 

[John]

Thanks, this worked. I thought I had tried this previously, but I
must have not had it exactly correct.

-- John

I'm assuming you have Conditional Formatting on your version of Access.
Click on the txtB control.
Click Format + Conditional Formatting
Set the Condition 1 drop-down box to:
Expression Is
In the Text box alongside this drop-down, write:
[txtB] <> [txtA]
Select the color, etc. for this condition.
Exit.

--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.

Hi - Although I have looked through several conditional formating
posts, I have not seen any that have helped with this problem. I have
a continuous form that shows Index, txtA and txtB for several Index
values. On each row, I want to set the background of txtB to grey if
it does not equal txtA. Thanks for any help.