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