Hi, Bhavbhuti

you can use method of grid or form

*grid::SetDYNAMICBACKCOLOR(lcName)
LOCAL loCol
loCol=EVAL("THIS."+ lcNAME )
RETURN IIF((NOT EMPTY(RECNO(THIS.RECORDSOURCE))) AND ;
                   (loCol.ENABLED AND (NOT loCol.READONLY)), goApp.nBackColorFld, ;
                   IIF(goApp.nOSVersion < 5.01, goApp.nBackColorForm, THIS.BACKCOLOR))


*grid::ProcessColumn()
.DYNAMICBACKCOLOR = "THIS.Parent.SetDYNAMICBACKCOLOR('"+.NAME+"')"

MartinaJ

>Hi all
>
>In my grid class I have a ProcessColumn() method to go through each column and set it's DynamicBackColor. I have managed to reach 190 characters:
>

	.DYNAMICBACKCOLOR = "IIF((NOT EMPTY(RECNO('" + THIS.RECORDSOURCE + "'))) AND (THIS." ;
>		+ .NAME + ".ENABLED AND (NOT THIS." + .NAME ;
>		+ ".READONLY)), goApp.nBackColorFld, " ;
>		+ "IIF(goApp.nOSVersion < 5.01, goApp.nBackColorForm, THIS.BACKCOLOR))"

>
>Now I need to add one more condition for columns that contain a class which range checks numeric values entered by the user and need a different color if the range check fails.
>
>Is this the only way to keep piling in IIF() for this or can I do something better?
>
>Thanks and regards.