Access Listbox: Change header font size/color

Posted on 2009-12-22
Last Modified: 2013-11-28

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

Question by:donisanp
    LVL 39

    Accepted Solution

    No, you cannot selectively change parts of the standard listbox. Leban's Enhanced ListBox control ( gives you more control. Or you can use a subform instead., "" will give you some help on how to do that.
    LVL 75

    Assisted Solution

    by:DatabaseMX (Joe Anderson - Access MVP)
    IF ... you want to spend some $$$

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

    just an fyi ....


    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    This article is a continuation or rather an extension from Cascading Combos ( and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now