Access Listbox: Change header font size/color

Experts:

Is there a property control for a listbox that can be changed in VBA to modify the font size and/or color?  This would be separate from changing the properties on the items contained within the listbox.  

More specifically, I have a listbox with 6 columns and 20 rows.  I want the headers for the six columns to be gray in color and size 8pt font.  The row items I would like to remain 6 pt font and black in color.  

The data for the listbox is set by using sql: myListbox.rowsource = "[my sql statement]"

Thanks
donisanpAsked:
Who is Participating?
 
thenelsonCommented:
No, you cannot selectively change parts of the standard listbox. Leban's Enhanced ListBox control (http://www.lebans.com/listboxenhanced.htm) gives you more control. Or you can use a subform instead. www.thenelson.name/#ReportFormTricks, "www.thenelson.name/#ReportFormTricks" will give you some help on how to do that.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
IF ... you want to spend some $$$

http://www.dbi-tech.com/ComponentPage_ctList.aspx

and you get a LOAD of other cool controls with the package ....

just an fyi ....

mx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.