Avatar of mounty95
mounty95
Flag for United States of America

asked on 

Access Checkbox Form Field from a SQL Database

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.
DatabasesMicrosoft AccessSQL

Avatar of undefined
Last Comment
mounty95

8/22/2022 - Mon