how to highlight a row in a listbox? (1 Viewer)

[killyridols]

Hello,

I have a form where i have a combo box where I can select a desired sample id. Then, I have a listbox which then shows all of the species that occur in that sample and their relative abundance.
Would there be a way that I could highlight the record with the maximum abundance each time I select a new sample??

Thank you!

 

[MarkK]

How about sort the RowSource of the list by abundance so max is always first?

 

[Endre]

Try Microsoft Image Combo Box as ActiveX Control....


http://www.access-programmers.co.uk/forums/showpost.php?p=873923&postcount=12

 

[Rx_]

Probably a little late for you... but for others:
This did not help me for my situation. So, I created the following code and posted it. It may or may not fit your case.
http://www.access-programmers.co.uk/forums/showthread.php?t=191094