Column Headings on a Listbox?

[RockNRoll]

Greetings,

Is there a way to show column headings on a listbox, or do I need to create
separate labels above the list box? Thanks,

-Dave

 

[tina]

the listbox control has a property called ColumnHeads. set the value to Yes.

 

[Kevin Sprinkel]

Change the List Box' Column Heads property to Yes. It's
No by default using the wizard.

Kevin Sprinkel

 

[RockNRoll]

Tina and/or Kevin,

Can I change those column headings? The field names in our SQL server are
cryptic at times.

Thanks,
-Dave

 

[fredg]

Tina and/or Kevin,

Can I change those column headings? The field names in our SQL server are
cryptic at times.

Thanks,
-Dave

You can change the field heading in the Row source property of the
list box SQL:

Select TableName.Field1 as ANewName, TableName.Field2 as AnotherName
from TableName Order by TableName.Field2;

 

[Van T. Dinh]

You can use Aliases in your Query / SQL String and the ListBox Columns will
use the Aliases. Something like:

SELECT Cryptic1 AS Meaningful1, Cryptic2 As Meaningful2 ...
FROM ...