InstantForum 2017-1 FinalStrataFrame Forumhttp://forum.strataframe.net/StrataFrame ForumTue, 09 Jun 2026 09:28:39 GMT20http://forum.strataframe.net/FindPost779.aspxI have a db column defined as char(1) that I want to bind to a checkbox.&nbsp; When retrieving a row if the value is 'Y', the checkbox should be checked.&nbsp; For any other value the checkbox should be unchecked.&nbsp; When inserting/updating&nbsp;the row if the checkbox is checked the value should be 'Y'.&nbsp; For unchecked, the value can be 'N'.&nbsp; If this isn't possible, what datatype should be used.&nbsp; Thanks!! :unsure:Fri, 07 Apr 2006 09:50:07 GMTfrankahttp://forum.strataframe.net/FindPost780.aspxFrank,</P><P>If you want to use this type of functionality you can, but it will take a little work.&nbsp; The most common data type used for a checkbox is a bit or some type of integer data type.&nbsp; You can use the smallest available integer data type and it will work.&nbsp; 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.&nbsp; If you already have some existing databases that you will have to interact with and it will be&nbsp;difficult to change the data structure itself, then you may want to invest some time and modify a checkbox control to meet your needs.&nbsp; Let me know if this is the direction you choose to go.Fri, 07 Apr 2006 09:50:07 GMTTrent L. Taylor