>>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))"

thanks guys.

nick