2 color row results in a list box?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm going to attempt this, but just in case someone has already done it can
save me the trouble...

I have a listbox that has 2 types of results -

Rows where a checkbox called "done" is either
checked or
unchecked

I'd like to color the checked rows "Blue"
and the unchecked rows as "red"

The trouble that I am forseeing with it is that you have to actually select
a row for a current event to fire, and if you write code for each instance of
the checkbox, the formatting will be cancelled out.

I'd like the rows to stay their respective colors everytime the form is
opened.

Thanks in advance!
 
Sorry, but you can't set different colors with a list box.
You can create a sub form that looks like a list box, and use the
conditional formating to set the colors.
You can also use a grid, but it's involved more work then the advice above
 
It can't be done with a listbox.

You could try using a subform, with conditional formatting to get the two
colours.
 
jonefer said:
I'm going to attempt this, but just in case someone has already done it can
save me the trouble...

I have a listbox that has 2 types of results -

Rows where a checkbox called "done" is either
checked or
unchecked

I'd like to color the checked rows "Blue"
and the unchecked rows as "red"

The trouble that I am forseeing with it is that you have to actually select
a row for a current event to fire, and if you write code for each instance of
the checkbox, the formatting will be cancelled out.

I'd like the rows to stay their respective colors everytime the form is
opened.
Click to expand...

You can not use, much less change, the colors in a list box.
Furthermore, list boxes can not display a check box.

However, if you use a continuous subform instead, then you
can use Conditional Formatting to get the colors you want.
 
Back
Top