Listbox Column Colours

  • Thread starter Thread starter Steven Buick
  • Start date Start date
S

Steven Buick

Does anyone know how to colour the columns in a listbox
individually? I am writing a stock control database with a
listbox on the products form which displays the product
name, amount in stock and selling price. I would like to
make the product name column a different colour from the
others to highlight it. I am using Office XP Developer.

Thanks.
 
You cannot accomplish this withe standard ListBox control. Use a SubForm
with COnditional Formatting instead.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
I didn't think it was possible with a normal listbox but
can't use a subform as the listbox finds a record on my
form when it is clicked. I've seen colours on other
databases but looks like Access has still to catch up!

Regards,

Steven
 
YOu can easily add code behind the SUbform to give you the same
functionality that currently exists behind your ListBox control.

--

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