H htadis Registered User. Local time Today, 05:45 Joined Dec 17, 2014 Messages 61 Feb 3, 2015 #1 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
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
pr2-eugin Super Moderator Local time Today, 01:15 Joined Nov 30, 2011 Messages 8,494 Feb 3, 2015 #2 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;
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;
H htadis Registered User. Local time Today, 05:45 Joined Dec 17, 2014 Messages 61 Feb 3, 2015 #3 Many thanks Paul. Trust that will work. Shall chk and revert.
pr2-eugin Super Moderator Local time Today, 01:15 Joined Nov 30, 2011 Messages 8,494 Feb 3, 2015 #4 Good Luck
H htadis Registered User. Local time Today, 05:45 Joined Dec 17, 2014 Messages 61 Feb 4, 2015 #5 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.
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.
pr2-eugin Super Moderator Local time Today, 01:15 Joined Nov 30, 2011 Messages 8,494 Feb 4, 2015 #6 Under properties you should have the option Text Align
H htadis Registered User. Local time Today, 05:45 Joined Dec 17, 2014 Messages 61 Feb 4, 2015 #7 Many Thanks Paul. Really appreciated.