Conditional Formatting

  • Thread starter Thread starter MrFlicks
  • Start date Start date
M

MrFlicks

Hi

Hope you can help. I am using ACCESS 2003.

I have done a fair bit of conditional formatting but there is one Combo
control which I can't seem to get to work with conditional formatting.

It is a combo box which is generated from a table of names (say Jane, Peter,
and Fred). If the value in the combo box is = Jane, I want the box to be
RED.

Pretty straightforward you would think, but I can't get it to work. I have
tried many of the options.

Am I missing something? Does CF not work with combo's?

Any ideas?

Thanks

Ian
 
How many columns as in the combo box? If there is more than one, which one
is the Bound Column, because this will be the Value of the combo box. If
it's not the column with the name in it, then it won't equal Jane. You can
set the Conditional Formatting to use an expression though, then define
which column to look at.

Example:
cboComboBox.Column(1)="Jane"

The Column property is zero based, so 0 is the first column, 1 is the
second, etc.
 
Wayne Morgan said:
How many columns as in the combo box? If there is more than one, which one
is the Bound Column, because this will be the Value of the combo box. If
it's not the column with the name in it, then it won't equal Jane. You can
set the Conditional Formatting to use an expression though, then define
which column to look at.

Example:
cboComboBox.Column(1)="Jane"

The Column property is zero based, so 0 is the first column, 1 is the
second, etc.
Click to expand...


Thanks Wayne, that sorted it.

IAN
 
Back
Top