>>>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?