>I have 3 differnt letters in one of my fields "D","R",or nothing I want to display 3 differnt words in my grid for each record in that field like if there is a "D" in there it says defaulted or "R" then Redeem would show. Then for the blank one I want to show the word ACTIVE in the cell of my grid. I was able to use the IIF() statement to check for 1 letter but if i have 2 or 3 differnt checks to do iff() only works to check for 1 state. I Tried to put a case statement in the control source for my coloumn but it wont take it. I'm just learning how to program in VFP this stuff probably sounds basic to most of you guys.

(Iif(orders.status='D','DEFAULTED',IIF(orders.status='R','REDEEMED','ACTIVE')))

Iif() function can be extended up to n conditions.

DO CASE can not be used as controlsource for columns. You can only use on line Expression.

HTH