displaying boolean values from SQL Server as checkboxes

Question

Consider an Access front end and SQL Server 2008 backend. Access boolean datatype values are displayed as checkboxes on their forms. I want similar functionality except that my data backend is SQL Server 2008

One of my fields is a 0 or 1 in SQL Server, and when I display this data on my form in Access I want it to be displayed as a checkbox.

Is this possible?

Answer 1

Delete the control from the form if it's present. Open the Toolbar and place a check box on the form. Then change the check box Control Source to the SQL Server field. Do not choose the Triple State option unless the field on SQL Server happily supports null values.