Dimitry you mean select padr(alltrim(ID_FIELD),10,' ') + DESC_FIELD as MYNEWFLD
and then on the drop down list you set DataTextField as the mynewfld.
Everything should work fine.
>Follow up question:
>
>I created a two-field expression by selecting from the VFP table as following:
>
>
>select padr(alltrim(ID_FIELD),10,' ' + DESC_FIELD as MYNEWFLD
>
>
>But the drop-down-list ignores spaces used to pad the ID_FIELD.
>Instead the DLL only shows one space, therefore, the alignment of
>the two column does not work.
>
>What character can I use in place of the space (in the PADR()
>above) to make it work? Is there a CHR(n) that does not show but
>still would be recognized by ASP.NET?
Alexandre Palma
Senior Application Architect