Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Combobox - how to concatenate two fields for controlsour
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00669624
Message ID:
00669647
Views:
15
Chris

I believe that you can just set
RowSource = trim(v_allcontacts.co_firstname)+" "+trim(co_surname)
HTH

>Hi I am using a combobox with these properties...
>columncount = 2
>style = dropdown list
>controlsource = v_contacts.co_firstname
>rowsource = v_allcontacts.co_firstname, co_surname
>rowsourcetype = fields
>boundcolumn = 1
>
>This displays the first name in the combox box when the combo is in it's "up state" (sorry - can't think of a better deescription!!!) but really I would like to display the surname aswell?
>
>Also when the combo is dropped down I would really like one column containing the concatenated firstname and surname rather than the two columns with a lot of spaces...
>Thanks for any ideas/comments on how to get this behaviour...
Caroline
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform