I have a grid column that contains a command button, which launches a memo edit form when clicked. I want to color the caption of the button to be either blue if there is a value in a memo field or black if emtpy.

I have tried using:

.column32.dynamicforecolor = 'IIF( EMPTY(tmpfcis.fciscomm), "RGB(0,0,0)", "RGB(0,0,255)" ) '

But this results in no coloring. If i use the following:

.column32.dynamicforecolor = IIF( EMPTY(tmpfcis.fciscomm), "RGB(0,0,0)", "RGB(0,0,255)" ) 

(i.e. no quotes around the IIF) the captions on all of the commandbuttons are blue.

I've done this before but cant recall what worked.