Bela,

This is a VERY *interesting* """feature"""!

Did you read this in the docs, or did you 'just happen to come across it"?

I would really like to know the source, and I offer my congrats if you stumbled on it yourself and figured out the "rules".

Cheers,
Jim N

>Hi Frank!
>
>I read your threads with Barbara and Jim.
>
>So, your rowsource is something like this: alias.field1, field2, fieldn
>And you want change the format of fields without SQL. I met this problem, too. I use the following solution:
>RowSource: MirrorFunc(myalias.field1), anyfunc(AnyRelatedTable.AnyField), ...
>
>function MirrorFunc
>lparameter data
>return data
>
>It is important, that without Mirrorfunc, you cannot use functions, in RowSource. (More precisely, if first field is not in function, any other cannot be, also.) But with it, you can use any function, and additionally, the rest fields can come from other tables! But without functions, It is impossible. (As I know.) The first named table is the main parent table! In this example, the MyAlias table.
>
>
>BB
>
>P.S.: I used VFP 5.0
>
>
>
>>>>Listbox using rowsourcetype of 6 and one of the fields is not charactor but is numeric unstead
>>>>
>>>>I have created a listbox with a rowsourcetype of 6 which is field and one of the fields in the
>>>>listbox is numeric. The column will not show up that is numeric in the listbox the other columns will show up.
>>>>
>>>>What do I have to do I can not change the field type in the table.
>>>
>>>Frank I tried this on both VFP3 and VFP5 and had no problems. In both cases I set the numeric field to the bound field and then changed the bound field to one of the character fields with no problem.
>>>
>>
>>>Please write again with as much information as you can:
>>>
>>>1. How many columns in your listbox?
>>>2. Which column is bound?
>>>3. What data is in each column (numeric or character)
>>>4. VFP3 or 5? And which version (5.0 or 5.0a, 3.0 or 3.0b)
>>>
>>>Add anything else you can think of.
>>>
>>>Barbara
>>
>>
>>*****************************
>>
>>I Found out that It is visual problem and the value does display if numeric but I want to modify the value by change the value by to change the value by ltrim() the contents.
>>
>>Frank
>>
>>****************************