troubleshooting Question

CheckBoxes on Form Bound To SQL Server Table

Avatar of mlcktmguy
mlcktmguyFlag for United States of America asked on
Microsoft AccessMicrosoft SQL Server
8 Comments1 Solution448 ViewsLast Modified:
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'?
ASKER CERTIFIED SOLUTION
Log in to continue reading
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform for $9.99/mo
View membership options
Unlock 1 Answer and 8 Comments.
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
The Value of Experts Exchange in My Daily IT Life

Experts Exchange (EE) has become my company's go-to resource to get answers. I've used EE to make decisions, solve problems and even save customers. OutagesIO has been a challenging project and... Keep reading >>

Mike

Owner of Outages.IO
Phoenix, Arizona, United States
Member Since 2016
Join a full scale community that combines the best parts of other tools into one platform.
Unlock 1 Answer and 8 Comments.
View membership options
“All of life is about relationships, and EE has made a virtual community a real community. It lifts everyone's boat.”
William Peck

Member since 2004