Franco,

Thanks for that info. I'll use Substr() until VFP8

Regards,

Gerard

>In VFP8 we'll have maxlenght to combo too....
>Until next year (:)) you can use substr() in your sql command
>
>Franco
>
>>I have a combo box whose source is a SQL command taking out a no. of fields.
>>I then want to be able to limit the size of each displayed column to say, 15 characters, but the combo box seems to be taking the width of the columns from the size of the fields selected in the Table.
>>I have set the ColumnWidths property but it does'nt seem to have any effect.
>>
>>Anybody got any ideas.
>>
>>Regards,
>>
>>Gerard