>>>>>>Here is a strange one. I have a combo-box on a very busy screen. The combo-box is populated from an array which is created via an SQL statement that reads a table of 300-400 records. Some here is where the strangeness begins: The user entered a value of "Oil & Grease" into the valid value table that is used to create the array for the combo-box. The combo-box drop-down list displays Oil & Grease. After selecting Oil & Grease the "&" is converted into an "_" (underscore) for the display value. Any input is appreciated! tia Steve.
>>>>>
>>>>>trying to do a macro substitution?
>>>>>
>>>>>used to work on a system where the & sign designated field on screens, reports. couldn't use it in captions, etc. haven't seen that in vfp, but brings back some odd memories.
>>>>>
>>>>>anyhow, maybe it is just having trouble displaying that in combo. have you tried other symbols?
>>>>
>>>>Sure enough, it looks like a VFP 3.0b bug. I just created a little form with a combo-box that is populated from a hard-coded array setup in the Init. And the style of combo-box is drop-down list. Try it.
>>>>
>>>>Create a form with a combo-box. Change the style to drop-down list. Change the source to laTest array and source type 5-Array. Create a little array laTest[4] that includes text strings with the "&" symbol. In the Init code. You will clearly see this bug. I am still trying to get to the MS KB for additional reference, but I am suffering the bandwidth blues... Any other comments are welcome.
>>>
>>>Hi,
>>>
>>>I have a combo-box Combo1:
>>>
>>>Combo1.Style=2-Dropdown List
>>>Combo1.RowSource= SELECT CodeE, NameE, CodeReg FROM N_Reg WHERE ISNULL(EndDate) INTO CURSOR TempCursor
>>>Combo1.RowSourceType=3-SQL Statement
>>>
>>>One of the N_Reg elements is "I & I". I haven't any problems when
>>>I choose I & I from my combo-box .
>>
>>
>>Maybe a work-around? But I use arrays throughout my system. Try your example with into Array laTest and change source type to 5-Array. Let me know if U see it! Steve.
>
>I created a form (Form1) with combo-box (Combo1):
>
> Combo1.RowSource=laTest
> Combo1.RowSourceType=5-Array
>
> Form1.Init code
>
> LOCAL ARRAY laTest(4)
> laTest[1]="E1"
> laTest[2]="E2"
> laTest[3]="I & I"
> laTest[4]="Oil & Grease"
>
>No problems again. (I work with VFP 5.0)
>
>Stoyka

Hi,

I created the same form (Form1) with VFP 3.0 . After selecting l & I "&" is converted into an "_".

Stoyka.