Access 2013, SQL Server Developer 2014
I am new to SQL but have been working with Access for a very long time. I have the SQL DB defined and some of the tables populated. I currently have the SQL table linked to the Access front end using the Linked Table manager.
I am creating a new form, bound to a SQL linked table using the form Wizard.
In the wizard I select the linked table fields that I want on the form. The form is created containing the select fields. A couple of the fields are defined as 'Bit' in the SQL table. They show as Yes/No if I look at the table design in Access.
In the past, when using an Access back end DB and the form wizard, type 'yes/no' fields are created on the form as check boxes, which is what I want.
When the form wizard creates the 'bit' fields on the new form, they are created as textboxes. If I right click on one of these fields and select 'change to', Checkbox is not permitted. Only 'label', 'listbox' and combobox are allowed.
Either with the form wizard or by some other means, how can I make the SQL 'bit' field appear as, and function properly as a 'checkbox'?