Jerry,
It looks like l_User is going out of scope. The variable disappears as soon as the command button Click() method completes. When the grid columns try to reevaluate the DynamicBackColor, the variable's gone. It would be better to add a property to your form (let's call it l_User) and do this:
THISFORM.l_user = "Bob"
myGrd.SetAll("dynamicbackcolor", ;
"IIF(myfield = THISFORM.l_User, RGB(255,0,0), RGB(255,255,255))", "Column")
>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