list box with different colors RRS feed

  • Question

  • Hi Team, I need help on the following situation, Request your help.

    Situation is:

    List box has 5 cols and 1500 rows., one of the columns will be status, and the status would be Completed or In-Progress or Not Applicable, and color codes to be red or green or yellow respectively.  based on the value in the status column, the background color of the cell should change.

    this list box is linked to a table from which data is retrieved.

    similar to conditional formatting in Excel.

    with regards,
    Repath Athyala

    Love the Love that Loves the Love and Hate the Love that Loves the Hate.

    Thursday, March 19, 2015 10:53 AM


  • You cannot do this with a standard list box control.  A way to achieve the effect you want would be to use a subform in place of the list box, and apply conditional formatting in the subform.  With careful design and appropriate code in the subform's module you should be able to mimic a list box's appearance and functionality reasonably well.  If you wish it to be multi-select you could introduce a Boolean (Yes/No) column into the table from which the list box's RowSource is drawn and bind a check box to this in the subform.

    Ken Sheridan, Stafford, England

    • Proposed as answer by Caillen Friday, March 20, 2015 8:22 AM
    • Marked as answer by Caillen Thursday, March 26, 2015 1:52 AM
    Thursday, March 19, 2015 11:22 AM