Colour of Column Headings

[akinia]

Hi eveyone

Is there a way to change the column heading of a listbox ?

Thanks for your answers.

 

[cranebill]

I think you are asking about changing the color of the caption for a list box correct? If so will this be a static change or dynamic?

 

[akinia]

Hi cranebill

I'm not sure I understand well what you said but when You go in the listbox properties (format), you can select for column heads. I want to know if it is possible to change the back and the fore color of these labels generated by the SQL using VBA ?

 

[cranebill]

By heading you mean the text contained beside the textbox, correct?

 

[akinia]

Hi Cranebill,

I've created my listbox using a SQL statement. Here you can get an overview of the result:

ID CompanyN NbEmpl Seller
1 Ardatis 240 Max
2 GialTech 110 Miguel

The first row which is the heading is the row I want to change the colour. They are the field name coming from the query.