>Hi,
>
>I have a ComboBox based on a "Contacts" view. In this view I have 6 fields. I want my first column to be a concatenation of the first 3 fields, my second column the 4th field and so on.
>I tried in the RowSource property :
>
>v_Contacts.ds_tratamento_pre+v_Contacts.nm_contact+v_Contacts.ds_tratamento_pos,v_Contacts.dp_contact,v_Contacts.ncg_contact,v_Contacts.id_contact
>
>And it didn't worked.
>
>If I create 6 columns with :
>
>v_Contacts.ds_tratamento_pre,v_Contacts.nm_contact,v_Contacts.ds_tratamento_pos,v_Contacts.dp_contact,v_Contacts.ncg_contact,v_Contacts.id_contact
>
>everything works fine (but it's not exactly what I want).
>
>I know that must be something stupid that I'm doing, but I could not find any references to this problem in the documentation.
>
>Regards,

Create a temporary cursor using SELECT - SQL. Do the concatenating there. Then set the rowsourcetype property to 3 and the rowsource to the name of the cursor.

Hope this helps.