mlcktmguy
asked on
CheckBoxes on Form Bound To SQL Server Table
Access 2013, SQL Server Developer 2014
Background
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'?
Background
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'?
By the way.
In mssql a bit field can be NULL or 0 or 1
(3 possible states)
In Access a yes/no is only yes or no
And
The default could be 1
In mssql a bit field can be NULL or 0 or 1
(3 possible states)
In Access a yes/no is only yes or no
And
The default could be 1
ASKER
I double checked the definition. All of the bit fields in the table bound to the form I'm creating appear to have a default of 0. I don't see any [Null].
Each field has this definition in its column properties
Default Value or Binding ((0))
Each field has this definition in its column properties
Default Value or Binding ((0))
well that's me out then - sorry
ASKER
No reason to be sorry, all suggestions are welcome and encouraged
ASKER
I was thinking this might be a common thing that Access developers encountered.
Anyone else have ideas?
Anyone else have ideas?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks
I believe that is necessary. https://support.microsoft.com/en-gb/kb/280730