Change colour of column heads in unbound box?

[YNWA]

Hi,

i have an unbound box which looks at a query to pull through columns with ID, name, DOB etc... on.

is it possible to code in some colour for the column header?

Thanks
Will

 

[gbnz]

Yes you can change the .backcolor of either a textbox or a label in Visual Basic.

 

[llkhoutx]

Look at the header controls' (i.e. the label's) properties, there are ones for the foreground and for the background. Yu can set the background color there and programmatically.

 

[YNWA]

I think my box is a list box that displays results based on a query.

Can i change list box heading?

 

[gbnz]

I think my box is a list box that displays results based on a query.

Can i change list box heading?

That is a good question. Listboxes are different...I don't know exactly what you are doing with it, but you could however change the listbox into a subform that looks at your query and then customize your title row however you like.

 

[llkhoutx]

Yes, a heading is a label. Labels are associated with various controls, but they're still label. A label is a control type. Check the properties of the label you want to change color.