How get column headings in a listbox ???

[gazolba]

MS Access help (what a pathetic thing!) talks about field names and captions but there is no caption property ???

I need the column heads to position automatically based on the column widths.

 

[FancyPrairie]

Not sure what you're trying to do, but when you define a field within a table, there is a caption property. When you drag a control onto a form or report, the caption property, defined in the table, will be the label for that control. If you do not define the caption property for the field in the table, then Access, by default, uses the name of the field for the label (or column heading in datasheet view)

 

[PHV]

What about the ColumnHeads boolean property ?

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[FancyPrairie]

Your right PHV, I got focused on the text of gazolba message and forgot about the title, which explained the problem (caption in list box)...dah

 

[gazolba]

I set columnheads to YES but where do the column headings come from? how do I specify them?

 

[PHV]

This depends on the RowSourceType.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[cgarts]

You can make the verbiage you wish to be tour headers if you add the AS statement into your rowsource.

SELECT TblContacts.ContactID, [FirstName] & " " & [LastName]
AS FullName
FROM TblContacts

FullName will appear as a header name.

In the graphic query builder window, Adding "FullName:" (without the quotes) before [FirstName] & " " & [LastName]
will do the same thing.

Best

C