Conditional Formatting Question

  • Thread starter Thread starter Scuda
  • Start date Start date
S

Scuda

Hi All, trying to do something like this and I am getting stuck.

I have a combo box and a text box right next to it for comments. When "UC"
is selected within the combo box, I would like the text box NEXT to it to
turn red. I have tried pretty much all I can think of and I am stuck!!

Thanks so much.

Steph
 
Have you actually tried "Conditional Formatting"?

1. Select the textbox
2. Depends on what version you have, but find the Conditional Formatting
option the format menu. This will popup a dialog box.
3. Leave the default formatting alone
4. In condition 1, select "Expression Is" in the first combo box.
5. You will have to play with this a bit (but enter somthing like the
following into the textbox to the right: [FieldName] = "UC"
where you replace "FieldName" with the name of the field that is bound to
your combo box.
6. Select the appropriate font and background, then click OK.
--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.
 
A slight expansion on Dale's comments.

He describes everything fine.

However if the bound field on that combo box is other than the values
"UC" etc (for instance it is the ID # of the underlying query which is
not being shown), then instead of testing for "UC" you have to test
for the ID # or whatever is the value of the bound field.

Ron
 
Back
Top