>I am trying to hightlight some grid rows so the user can highlight just his records.
>
>The first example works, the second doesn't.
>This code is in a Command button click()
>
>Example 1:
>myGrd.SetAll("dynamicbackcolor", ;
>"IIF(myfield = 'Bob', RGB(255,0,0), RGB(255,255,255))", "Column")
>***Works
>
>Example 2:
>l_user = "Bob"
>myGrd.SetAll("dynamicbackcolor", ;
>"IIF(myfield = l_user, RGB(255,0,0), RGB(255,255,255))", "Column")
>***Gives a error.
>
>
>How can I get example 2 to work.
>
>Thanks,
>
>Jerry Tovar
Example 2:
l_user = "Bob"
myGrd.SetAll("dynamicbackcolor", ;
"IIF(myfield ='"+l_user+"', RGB(255,0,0), RGB(255,255,255))", "Column")
Edward Pikman
Independent Consultant