Need help w/conditional format of text box on form

  • Thread starter Thread starter John
  • Start date Start date
J

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.
 
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.
 
Thanks, this worked. I thought I had tried this previously, but I
must have not had it exactly correct.

-- John

Fredg said:
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.


John said:
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.
Click to expand...
Click to expand...
 
Back
Top