>>>>>>Hi
>>>>>>
>>>>>>I am searhing a file with 100 records on it - all the records are displayed in a grid
>>>>>>
>>>>>>When my search finds the record i want how do I display it at the top of the grid - and how do I give a dark blue backcolor to the line of the found item
>>>>>>
>>>>>>Colin
>>>>>
>>>>>Just put this row first in the order and highlight using dynamic back color and some extra field, say, lFound.
>>>>
>>>>Thanks but (stupid question) how do I put it first in the order
>>>
>>>Essentially like this, in pseudocode (if I remember correctly)
>>>Yourform.Lockscreen=.T.
>>>lnGridHeight=yourgrid.height
>>>yourGrid.height=20
>>>Locate for whatever
>>>yourGrid.height=lnGridHeight
>>>Yourform.Lockscreen=.F.
>>
>>thanks i will try
When I try this with this x=code I get aliias grid1 not found - grid1 is my grid on this form
thisform.Lockscreen=.T.
lnGridHeight=grid1.height
grid1.height=20 && You may have to change this value
Locate for TRIM(custref)=jjij
Grid1.height=lnGridHeight
thisform.Lockscreen=.F.
Your other idea I didn't understand
>
>I actually meant something different, but I think this idea may also work. I meant
>
>select .. order by lFound DESC, other fields
>GO TOP
Specialist in Advertising, Marketing, especially Direct Marketing
I run courses in Business Management and Marketing