With your code you also lose rushmore optimizing!

>I'd rather reccommend
>

>select * from stock_file where cstockid == padr(stock_id,len(cstockid)) into cursor cstock

>
>>Just a side note. Why do you use alltrim? It gives zero benefit, and your query won't be optimized. Instead use
>>

>>select * from stock_file where cstockid == stock_id into cursor cstock

>>>I want the user to pick the stock id:
>>>
>>>

>>>stock_id = inputbox('Stock ID','Input Stock ID', space(20))
>>>select * from stock_file where alltrim(cstockid)=alltrim(stock_id) into cursor cstock
>>>
>>>select cstock
>>>browse normal
>>>
>>>?cstock.cstockid
>>>

>>>
>>>how to make it looks better in the program?
>>>which controls can I use to replace browse normal?
>>>
>>>thanks for the advice
>>>
>>>Jerry