You can use expressions as ControlSource for the column, but not for the contained TextBox. Put the expression directly into the column. If the TextBox has a ControlSource, select the "Reset to Default" option to clear it.
>Hi Christian,
>
>Thanks for the reply. I tried that and it gives an error 'the data source for this object must be a variable reference'.
>
>
>
>>You could make sure you have a textbox control in the column, and set the column ControlSource expression to something like:
>>
>>
>>iif(Terminated, 'Terminated', 'Active')
>>
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)