Color on certain things

[Durien512]

Hey guys..

I have a form that displays inventory of goods.

there is a list box with a list all property. If they items are sold a sales order number appears next to it. Now with that in mind how can i have something that if there is a sales order number on that item then highlight it with a color?

 

[alteque]

Use the Sub Form_Current

This event fires everytime you move from one record to another. Then just check to see if the sales order number is a zero length string "" or isnull() and make your adjustments as necessary.

Hope this helps.

alteque