How to display customer combo box column headers 1

[steve728]

I know you can turn the Combo box headers on and off but,
is it possible to display my own choice of headers?

Steve

 

[cgarts]

This will show up as ModelDescription in the header

SELECT TblModel.ModelDesc AS ModelDescription FROM TblModel

Whereas this will show just ModelDesc in the header

SELECT TblModel.ModelDesc FROM TblModel

In the query design view, you can put YourDesiredHeaderName and a colon ":" before the fieldname or expression and the same effect will obtain.

Best,

C

 

[batteam]

You can if your combobox record source is either a query or a value list. If its a query, whatever the column names you define in your query will be the column names displayed in your combo box.

If its a Value List then: (from Access 'HELP')
If the RowSourceType property is set to Value List, the first row of data items entered in the value list (as the setting of the RowSource property) will be column headings. For example, if a list box has three columns and the RowSourceType property is set to Value List, the first three items in the RowSource property setting are used as column headings.

If your record source is a table and you must have different column headings, append the table of data to a temp table with column heading of your choice, then use that temp table as the record source.

Hope this helps. Good Luck.