I have created a list box that displays the items in an item master table. Can I have individual lines(records) in the list display in different colors based upon a value of a field in the item master? For instance if QTY on hand is zero, I would want that item to appear in red.
Do I need a subform for this instead to have it work?
I am VERY new to this so patience please.
I found the following code in an old post and I am unsure if it will work.
Thanks!
_____________
let us say that you have a combo box called [States] and a text box called [Text2], your code should be like
follows:
Select Case States
Case "AL" 'state of Alabama
States.ForeColor = vbYellow
Text2.ForeColor = vbYellow
Case "NY" 'State of New York
States.ForeColor = vbBlue
Text2.ForeColor = vbBlue
Case Else
States.ForeColor = vbBlack
Text2.ForeColor = vbBlack
End Select
Alaa Sallam
Let als
Do I need a subform for this instead to have it work?
I am VERY new to this so patience please.
I found the following code in an old post and I am unsure if it will work.
Thanks!
_____________
let us say that you have a combo box called [States] and a text box called [Text2], your code should be like
follows:
Select Case States
Case "AL" 'state of Alabama
States.ForeColor = vbYellow
Text2.ForeColor = vbYellow
Case "NY" 'State of New York
States.ForeColor = vbBlue
Text2.ForeColor = vbBlue
Case Else
States.ForeColor = vbBlack
Text2.ForeColor = vbBlack
End Select
Alaa Sallam
Let als