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.