Hello

I am trying to have a listbox where each row can be a different color to the other rows. This would be dependent on the content of the row.

I have tried googling around and no where seems to have an answer about how this is possible.

Thank for you for advice given, in advance :)

Kind Regards

Satal Keto

This is not possible in Access. You can only change the background colors for the entire control, not for a row. You can change the background colors of rows in a report, for example, but not within any control (list, combo, etc.)

Your option would be to create your own group of controls and use conditional formatting on each one, and allow them to act as a list box, but this would take some coding.

Did that help?

mmcdonal

Look it up at: http://wrox.books24x7.com

Yes that was helpful thank you.
Unfortunately not the answer I was hoping for but ow well I will just have to see about either making a new control or finding another way :)

Again Thank you :)