Listbox Column Colours

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.
 
S

Stephen Lebans

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.
 
S

Steven Buick

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
 
S

Stephen Lebans

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create custom labels from an csv file + Need items numerically counted out 0
Unable to display values in 2nd list box from 1st list box selection 2
Buttons and listbox to search in a form 6
printing from multiselect listbox 1
ADDING values from one listbox to another on same form 1
Text colour in ListBox entries 2
How to set focus on an ActiveX ListBox 7
different text colours in listbox 1

Top