Column Headings on a Listbox?

  • Thread starter Thread starter RockNRoll
  • Start date Start date
R

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
 
Change the List Box' Column Heads property to Yes. It's
No by default using the wizard.

Kevin Sprinkel
 
Tina and/or Kevin,

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

Thanks,
-Dave
 
Tina and/or Kevin,

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

Thanks,
-Dave
Click to expand...

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;
 
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 ...
 
Back
Top