Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4131
  • Last Modified:

Access Listbox: Change header font size/color


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]"

2 Solutions
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.
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
IF ... you want to spend some $$$


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

just an fyi ....


Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now