combo box

[Chris]

Is there a way to subdue lines in a combo box based on condition?

Ex: My combo shows all clients. One column indicates "Inactive" for those
that are inactive, others are blank. I would like those "Inactive" lines to
be a different color from the blank lines.

Is there a way?

 

[Ken Snell \(MVP\)]

No, this cannot be done in a combo box.

 

[fredg]

Is there a way to subdue lines in a combo box based on condition?

Ex: My combo shows all clients. One column indicates "Inactive" for those
that are inactive, others are blank. I would like those "Inactive" lines to
be a different color from the blank lines.

Is there a way?

No....

One possible solution would be to filter out of the combo box all
clients that are inactive so they don't even show.
You would use a query as the combo box rowsource and set the query
criteria to
<> "Inactive"
to show all Active members if the value is text, or
0
if the value is a check box true false value, and unchecked means
'Active'.

 

[Chris]

Thanks to you both. I did filter, but I want them to show in this case.

Wish it were so.
--
Thanks for your help,
Chrissy

No, this cannot be done in a combo box.