>>>>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.
Steve Medvid
Systems Analyst
Environmental Resource Management