Rich,
AFAIK you need to use a single IIF() statement in your Setall(), although you can nest it 4 deep to get all of your colors. In a VFP5 app I was unable to get a case statement to work. Haven't tried it since, though.
Barbara
>Help....
>
>I have been tring to create a grid that will change foreground and backcolors of the fields based on the data in thw database. I have tried using IIf statements and they work if I want only 2 color options, I am tring to get a total of 4 color options for each the foreground and the background.
>
>I have tried using case statements but then the grid does nothing.
>
>Any ideas??????
>
>Rich