>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.
Unfortunately I haven't seen this before. Check FAQ #7934. Setting DynamicForeColor directly wouldn't work. You need something like this:
.Column32.DynamicForeColor = "(thisform.myColor(this.Column32.myCommandButton,tmpfcis.fciscomm))"
lparameters toObj,tuValue
toObj.ForeColor = IIF( EMPTY(m.tuValue), 0, 0xFF0000 )
return 0
Cetin