Conditional Formatting in Combo Box (ACC2007)

[MeTed]

Hi all,

I have a form that has a combo box that grabs customer information from a
Customers table. When the user selects the appropriate company, it stores
the CustID field into the Jobs table. Here's what I'm trying to do. The
users are modifying the Customers table to reflect those who are on credit
hold. What they are doing is adding three asterisks after the CompanyName
so they can easily spot those on credit hold. What they want is to have the
field on the form turn red if the CompanyName contains three asterisks.
I've tried and tried to use Conditional Formatting to so just that, but I
can't seem to get it to work. My guess is because the form is only
displaying the CompanyName (and storing the CustID), my Conditional
Formatting rules aren't working when I try to use that field.

Any clues?

Thx

 

[Douglas J. Steele]

Yes, if you're referring to the combo box by name in your conditional
formatting, then the reference will strictly be to the bound field.

You could always try referring to the name via the Column collection.

NameOfComboBox.Column(1) refers to the value in the second column of the
selected row. (The Column collection starts numbering at 0)

 

[MeTed]

Excellent...works like a charm. Here's what I did for those looking to do
the same:

Right([CboCust].[column](1),3)="***"