<div>
Thank you Anders. &nbsp;I wasn't seeing the field in the control source of the form and had to modify that &quot;query&quot; to add the new field and was able to then change the form field type to checkbox. &nbsp;Thank you again!!!!!
</div>


<div>
<div class="content wysiwyg-content">
I have a SQL database field that I have added to a table that I have set the data type to INT. &nbsp;I have updated the table to set the value for the field to &quot;0&quot;. &nbsp;I have gone back and altered the table to uncheck the box to allow nulls.<br />
<br />
Now my problem. &nbsp;I have this SQL database connected to an Access datapoint. &nbsp;I have gone back to Access and refreshed the linked table in the Linked Table Manager to recognize the field that I have added.<br />
<br />
I now want to add this field to a form as a checkbox, but when I click and drag the field onto the form in Design View and then click Change To to hopefully change it to a checkbox, the checkbox is not an option.<br />
<br />
The form is based on a table, not a query so there is nothing to change there. &nbsp;I am not sure what I have done wrong or need to do to complete this simple task.<br />
<br />
Any help would be greatly appreciated.
</div>
</div>


I have a SQL database field that I have added to a table that I have set the data type to INT.  I have updated the table to set the value for the field to "0".  I have gone back and altered the table to uncheck the box to allow nulls.

Now my problem.  I have this SQL database connected to an Access datapoint.  I have gone back to Access and refreshed the linked table in the Linked Table Manager to recognize the field that I have added.

I now want to add this field to a form as a checkbox, but when I click and drag the field onto the form in Design View and then click Change To to hopefully change it to a checkbox, the checkbox is not an option.

The form is based on a table, not a query so there is nothing to change there.  I am not sure what I have done wrong or need to do to complete this simple task.

Any help would be greatly appreciated.

Access Checkbox Form Field from a SQL Database

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.