Hi Doug,

The reason you're getting 'Data type is invalid for this property' is because the colour values need to be in quotes.

Try:

Column1.DynamicBackColor = IIF(parent_itm = 'Y','13565902','16777215')

Gavin...

>Hi,
>
>I have a problem when re-defining a grid from a method of a form. The DynamicBackColor causes an error. The code (part only) for the grid redefinition is...
>
>

>.Column1.FONTSIZE = 8
>.Column1.CONTROLSOURCE = "vInventory.itemno"
>.Column1.DynamicBackColor = IIF(parent_itm = 'Y',13565902,16777215)
>.Column1.WIDTH = 125
>

>
>...the dynamicbackcolor value works OK only for the original grid definition on form show.
>
>Error...
>

>PROCEDURE..: FRMINVENTORY.BLDGRID6
>LINE NUMBER: 21
>DESCRIPTION: Data type is invalid for this property.
>CODE       : .Column1.DynamicBackColor = IIF(parent_itm='Y',13565902
>ACTIVE DBF.: VINVENTORY
>ACTIVE NDX.:
>ERROR NO...: 1732
>

>
>I look forward to a resolution to this.
>
>Regards
>Doug Johnston