>>>>>Hi,
>>>>>
>>>>>I have check box in a container used in a grid. I want the check box caption say "Yes" if the field it is bound to is .T./1 or "No" if .F./0. First I tried to do it in the Refresh method of the check box but it never fires (probably because the checkbox is in the container). Then I tried to put an IIF() expression in the Caption field but all it does, is showing the expression.
>>>>>How would you do it?
>>>>
>>>>IIRC you need an equal sign in front of the expression in the caption property.
>>>
>>>First, thank you.
>>>Would IIF() work as an expression? For example can I put in Caption the following expression (so far it does not work):
>>>
>>>=IIF( FIELDNAME, "Yes","No" )
>>>
>>
>>In a grid column, can't you just set the column controlsource to that expression and use the column's default textbox control?
>
>The grid column is "bound" to a container with many controls (textboxes, edit boxes, check boxes). So the column controlsource would not be applicable. It has to be done (if possible) within the container where the checkbox resides. Or in the checkbox itself.
>Thank you.
You'll have to use one of the "Dynamic" properties of the grid column calling a method on the container that will refresh its contents. Works perfectly for me.