I have a db column defined as char(1) that I want to bind to a checkbox.  When retrieving a row if the value is 'Y', the checkbox should be checked.  For any other value the checkbox should be unchecked.  When inserting/updating the row if the checkbox is checked the value should be 'Y'.  For unchecked, the value can be 'N'.  If this isn't possible, what datatype should be used.  Thanks!!

Frank,

If you want to use this type of functionality you can, but it will take a little work.  The most common data type used for a checkbox is a bit or some type of integer data type.  You can use the smallest available integer data type and it will work.  If you want to use a character value, you will have to modify some properties and change how the control interacts with the data slightly.  If you already have some existing databases that you will have to interact with and it will be difficult to change the data structure itself, then you may want to invest some time and modify a checkbox control to meet your needs.  Let me know if this is the direction you choose to go.