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