Help with list box on form.

[manic]

Hello all,
I need guidance with the following if possible:


I have a form with multiple list boxes that contains three columns; column (0) contains a part number, column (1) the quantity and column (2) the product code. Each list box represents a location on a warehouse and on these locations only certain products can be stored, so for example, listbox 1 is only supposed to have products with code 1F and so on. My question is the following : how can I make the list box background change to red if on a listbox that only product “1F” is supposed to be there but it also contains product “B”, so in other words if it does not belong there can the list box via VBA code be changed to a different color based on that list box having different product codes when only one type is supposed to be there?

[June7]

You want the listbox to change color if an erroneous item is in the list? Maybe possible but doesn't sound easy. Preventing erroneous items from appearing in the list should be easy.

[manic]

You want the listbox to change color if an erroneous item is in the list? Maybe possible but doesn't sound easy. Preventing erroneous items from appearing in the list should be easy.

It could be easier but the problem is that i get the information from "Reflection for unix and Open VMS" server and I have no control of the data. If I was able to have a visual of which locations have items that are not supposed to be there I can make people move them to the correct location i a warehouse.

[ssanfu]

Check out Stephen Lebans' site. He has an enhanced listbox control that *might* work.

http://www.lebans.com/listboxenhanced.htm