Super, that worked! Thanks!
>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')
>>>