Change Combo box headings

htadis

Registered User.
Local time
Today, 07:20
Joined
Dec 17, 2014
Messages
61
good day !

Could you please advise how can i change the combo box fields headings. by default it comes according to the table/query field name. I need to put some thing meaningful.

Kindly help.

brgds
Htadis
 
If your Query/Rowsource to the comboBox is something like
Code:
SELECT 
    tableName.FieldName1, 
    tableName.FieldName2
FROM 
    tableName;
You can change it as,
Code:
SELECT 
    tableName.FieldName1 [COLOR=Red][B]As MeaningfulHeading1[/B][/COLOR], 
    tableName.FieldName2 [COLOR=Red][B]As MeaningfulHeading2[/B][/COLOR]
FROM 
    tableName;
 
Many thanks Paul. Trust that will work. Shall chk and revert.
 
Thanks Paul. it's working nicely. Also can you tell me how to align data in the Combo box fields. any way for it ? by default it comes left align.
 
Under properties you should have the option Text Align
 

Users who are viewing this thread

Back
Top Bottom