Hi Harry,
The following should work if assigned to the DynamicBackColor property of the columns as is at the design time
IIF(diary.live,RGB(192,192,192),RGB(192,220,192))
Or you can use SetAll method of the grid
This.SetAll("DynamicBackColor","IIF(diary.live,RGB(192,192,192),RGB(192,220,192))","Column")
BTW, the DynamicBackColor is a property not a method.
>I have a diary integrated into my application. From the main module, I can browse the diary entries for a given account and doubleclick on any given line to go into the diary module proper to see the full detail of that record.
>
>When a diary entry is no longer relevant, users can delete them, or, if they want to retain history, simply mark them as no longer 'Live'.
>
>In the main module, it would be good, I thought, to have a visual cue, on the grid, to distinguish those items which are still live from those which aint. Rather than dedicate a column in already restricted space, I thought I'd borrow the technique used to give the "ledger" effect (alternating background colours in grid lines) which is done by using the code:
>
>IIF(MOD(RECNO(),2)=1,RGB(255,255,255),RGB(192,220,192))
>
>in the "DynamicBackColor" method of the grid columns.
>
>I figured:
>
>IIF(diary.live,RGB(192.192.192),RGB(192,220,192))
>
>would do the trick.
>
>It doesn't.
>
>Anyone any idea what I'm forgetting or why this wouldn't work?
--sb--