>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.
Chris,
Drop the double quotes
.column32.dynamicforecolor = 'IIF( EMPTY(tmpfcis.fciscomm), RGB(0,0,0), RGB(0,0,255) ) '
Gregory