>>>>>>>>What does table_fld look like?
>>>>>>>
>>>>>>>table)fld is 254 characters long. It will work when I say
>>>>>>>WHERE 'MODEM' $ table_fld
>>>>>>>but.. when I replace 'MODEM' with THISFORM.fld.VALUE, it will not work..
>>>>>>>
>>>>>>>help
>>>>>>
>>>>>>Ok....have you tried AT(thisform.fld.vlaue,table_fld)?
>>>>>>
>>>>>>Basically
>>>>>>
>>>>>>SELECT .....;
>>>>>>
>>>>>>WHERE AT(thisform.fld.vlaue,table_fld) > 0
>>>>>
>>>>>does not work, but thanks
>>>>How is your field getting its original value? What I am getting at is there might be some imbedded (unreadable) characters in your field. At the command prompt, open the dbf and select a record where your field = "MODEM". Does...
>>>>
>>>>? upper(alltrim(field))="MODEM"
>>>>
>>>>return .t. or .f.?
>>>>
>>>>If it returns .f. you will need to parse your field and get rid of the imbedded characters
>>>>
>>>>To parse try something like
>>>>
>>>>STORE UPPER(ALLTRIM(FIELD)) TO mTEST
>>>>STORE SPACE(0) TO mFieldString
>>>>FOR i=1 TO len(mTEST)
>>>> *TEST FOR A-Z
>>>> IF BETWEEN(ASC(SUBSTR(mTEST,i,1)),65,90)
>>>> STORE mFieldString + SUBSTR(mTEST,i,1) TO mFieldString
>>>> ENDIF
>>>>ENDFOR
>>>>
>>>>REPL Field WITH mFieldString
>>>
>>>thanks for the code... I need to strip out all characters, not just a through z.
>>>How would I do this?
>>>thanks again.. rob
>>
>>Rob! I am sorry that I interrupt. But as I understood we have resolved the problem already (use textbox instead of editbox). So, what is the reason to mislead people and still ask the same questions?
>
>I do not have a choice, I must use the editbox. This editbox is giving
>me problems when I search on it. I have everying worked out, thanks to
>you and others, but I am having problems after I hit the return key.
>My seach is not finding any records.
>I did use strtran(thisform.fld.value,chr(13),""), but it does not seem
>to work. I must have some other characters in the value. I really need to take my field and strip out everything but the value. any suggestions? (Christians do not mislead people)
Well, so ask Christians.
Edward Pikman
Independent Consultant