VBA Userform Listbox headers multi column in Access 2003

[patriciaxxx]

I have VBA Userform Listbox in Access 2003 database and I can't work out how to set values for the column headers.

I can set columnHeads = True

which will show the heads above each column but they are empty ie they have no name in them, how to I put the name in them?

I have looked at the rowsource property but it doesn't seem to be what is needed.

Any help would be appreciated

 

[combo]

Colum headers in userform listbox can be added only in excel and only if the list is linked with worksheet via RowRource. In your case you can add labels above or another list with one row.

combo

 

[patriciaxxx]

Hi combo

Everything I read was pointing that way, just couldn't believe it would be so.

Thank you for your help.

 

[combo]

It's not a big loss, built-in headers are rather ugly, no way to remove borders or use different font size/style.

combo