>I am build a grid programatically and trying to set DynamicBackcolor, but I'm getting errors saying "Data type invalid for this property." I'm not sure what is wrong here:
>
>

>INSERT INTO crs_grid1 (crsinst, crsprod, crsitemcode, crswho, crsdte, crsrequestamt, crsiid, crspid, crsird, crsaccptamt, crsdelivertype, crsqtyperunit) SELECT * from lv_whs_request
>
>	SELECT crs_grid1
>WITH thisform.pf1.p1.pf2.p21
>	.g1.RecordSource="crs_grid1"
>	.g1.RecordSourceType = 1
>	.g1.ColumnCount=8
>	.g1.readonly = .f.				
>	.g1.Refresh()
>	WITH .g1	
>...
>		.Column8.Sparse = .F.
>		*.Column8.optiongroup1.value = 1		
>		.column8.Alignment = 2 		
>		.column8.width = 150
>		.column8.backcolor = RGB(255,255,0)
>		.column8.forecolor = RGB(255,0,0)	
>		.column8.fontbold = .T.
>
>	ENDWITH
>...
>thisform.pf1.p1.pf2.p21.g1.columns[8].DynamicBackcolor = IIF(crs_grid1.crsqtyperunit=1,RGB(200,0,0),RGB(234,0,0))
>

>
>If I am creating a grid progamatically, is the "DynamicBackcolor" not allowed?
>
>thanks
>Nick

The expression should be in quotes, e.g.

DynamicBackcolor = "IIF(crs_grid1.crsqtyperunit=1,RGB(200,0,0),RGB(234,0,0))"