The most common source :) Set it to nothing before playing with the underlying source, that way you can keep formatting at designtime.
Cetin
>I forgot about the recordsource issue, where if you set it you lose your grid settings.
>
>Thanks,
>Larry
>
>>>I have a grid with ColumnCount set to 3. If I put a default value in the a Column's DynamicBackColor property...
>>>IIF(MOD(RECNO( ), 2)=0, RGB(255,255,255), RGB(0,255,0))
>>>...it does not work.
>>>
>>>But if I use...
>>>
>>>thisform.Grid1.SetAll("IIF(MOD(RECNO( ), 2)=0, RGB(255,255,255), RGB(0,255,0))","Column")
>>>
>>>in the init it works.
>>>
>>>Is this a bug?
>>>
>>>TIA,
>>>Larry Long
>>
>>Larry,
>>There is not such a bug. I think it's your code making it not to work. Are you sure Column's dynamicbackcolor is as you wrote at runtime (Open a debugger window and check)?
>>Cetin