Color in listbox

J

JKro

I populate a listbox from a query. Based on certain values in the query, I
want to highlight certain rows in the listbox. Is there any way I can do
this?
 
A

Allen Browne

No.

You could use a subform instead of the listbox, and use conditional
formatting to highlight things.
 
J

JKro

I forgot to mention that I need to interact with this listbox. Users will
select records based on the criteria in the listbox. I just want to draw
their attention to certain records in the list so they know to focus on them
(and more than likely select them).

Any other ideas? Thank you for your input
 
S

Stephen Lebans

Instead of color how about using SPACE or say "*" chars to draw focus to
specific rows.
See the sample here:
http://www.lebans.com/commandbars.htm
CommandBars.zip is a database containing functions to allow you to view
all of the MS Office CommandBar objects and CommandBarControl objects on
your system.

NEW - Jul. 27/2000 This version also demonstrates how to use a callback
function to fill a ListBox with multiple columns. Shows you how to apply
a limited form of Conditional Formatting to individual rows of the
ListBox.

History

Version 1.1

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
Top