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?