Rename drop list column heads

[Pastor Del]

I have a situation where the table field names that provide data for the
columns in a combo box are too long and I can not rename the fields. Is
there anyway to rename column heads in this combo box drop list?

 

[Jinjer]

Hi.

Open the table in design view. In the properties for each field is one
called "Caption". You can type in what caption you would like the user to
see. For example, if you have a field named "custname", you can put
"Customer Name" in the caption property, and that is how it will show up on
forms, combo boxes, list boxes, etc.

Hope this helps.

 

[Pastor Del]

Thank you for the fast & helpful answer

Hi.

Open the table in design view. In the properties for each field is one
called "Caption". You can type in what caption you would like the user to
see. For example, if you have a field named "custname", you can put
"Customer Name" in the caption property, and that is how it will show up on
forms, combo boxes, list boxes, etc.

Hope this helps.

 

[JimBurke via AccessMonster.com]

Just remember this part - 'that is how it will show up on forms, combo boxes,
list boxes, etc'. As long as that's what you want then you're good to go. If
for whatever reason you didn't want that to happen, you could just change the
combo box to be based on a query that selects the same fields from the table,
then rename the fields in the query, e.g. if the combobox uses 2 table fields
called Field1 and FIeld2, create a simple SELECT query that has those two
fields as the columns and rename the fields in the query's 'Field' row, e.g.
'NewDescrip1: Field1' and 'NewDescrip2: Field2'