I want to set the subitems in my listview control to a color other than black. I have got the ListItem (first column) to be red but I am unable to get the rest to be red.
Here is what I am doing:
Any ideas from anyone?
Here is what I am doing:
Code:
Do While Not rsSchedule.EOF
Set SchedItem = lstSchedule.ListItems.Add(, , rsSchedule("MO_NUMBER"))
SchedItem.SubItems(1) = rsSchedule("SCHED_DATE")
SchedItem.SubItems(2) = rsSchedule("ORDER_QTY")
SchedItem.SubItems(3) = rsSchedule("WC_ID")
If rsSchedule("ITEM") = txtXBundle Then
SchedItem.ForeColor = vbRed
SchedItem.SubItems(1).ForeColor = vbRed '<<=== Bombs out here. Error: "Invalid Qualifier"
SchedItem.SubItems(2).ForeColor = vbRed
SchedItem.SubItems(3).ForeColor = vbRed
End If
rsSchedule.MoveNext
Loop
Any ideas from anyone?