cField is name, and lContainedIn=.F.
also i found this in comments of the class
I got to looking through the code and noticed in the "builddata" method that the parentheses were out of place in the else clause of the 2 IIF() statements. The closing parantheses for the Left() function is behind the last quotation and closing parantheses and needs to be before.
i cannot figure out this.
Thanks
>What are the values of cField and This.lContainedIn at that point?
>
>>Hello all
>>
>>I downloaded the autocomplete combo box and if i selected lcontained=.f. i get a error message operator/operand type mismatch error.
>>
>>IF "'" $ LEFT(This.Text,This.SelStart)
>> cWhere = IIF(This.lContainedIn, 'UPPER("' + LEFT(This.Text,This.SelStart) + '") $ ;
>UPPER(' + cField + ')', 'UPPER(' + cField + ') = UPPER("' + LEFT(This.Text,This.SelStart + '")'))
>>ELSE
>>** Error Message appears here
>> cWhere = IIF(This.lContainedIn, "UPPER('" + LEFT(This.Text,This.SelStart) + "') $ ;
>UPPER(" + cField + ")", "UPPER(" + cField + ") = UPPER('" + LEFT(This.Text,This.SelStart + "')"))
>>ENDIF
>>
>>
>>Thanks for any input