>>>Hi,
>>>
>>>I have a column in a table of type nchar(1). The value in this column is "A" or "I". I want to bind this column to a check box and show in the caption of the check box "Active" (for 'A') and "Inactive" for 'I'
>>>
>>>I tried the following binding code but get error:
>>>
>>>

>>>this.chkStatus.DataBindings.Add("Checked", bindingSource1, "Status=='A'");
>>>

>>>
>>>What am I doing wrong? TIA.
>>
>>Why not make your life easier and just change the type of the column to bit 1=Active 0=Inactive?
>>True and False.
>
>Good point, Borislav. When I was writing the question I thought about the same. But I am sure, even if I change this column to a bit type there will be future cases where I may need to bind a check box to a string column.
>Thank you.

But how complex that could be?
CheckBox has 3 values:
True
False
NULL

So you could handle it with a simple bit field that allow NULL :-)