Colour changing fields in list box

[sgtblitz]

Hi there guys,

I need a little help on a little situation. Basically, my client for my school project wants to be able to see graphically if orders sent to their bookstore have been processed or not. So i suggested a change of cololour of the fields.

Now I have created a Form containing the orders as they are stored in a list box, (both already processed and unprocessed orders), now I want to be able to allow each item in the list box to be either Red (if unprocessed) or green (if processed) so the user can see which ones they need to deal with. Im guessing this would take some VB, but if anyone could help me, I would really appreciate it .

PS, if you do provide VB could you please explain a little of whats going on as i have to annotate all the code I use and im not too profficient in VB

Thanks a lot

Dan

 

[boblarson]

No need for VBA. Instead of using a listbox, which you cannot format, create a subform and format it to essentially look like a listbox and then look into FORMAT > CONDITIONAL FORMATTING for the formatting.