checkbox

G

Guest

I add 4 check boxes on a new form. These checkboxes are bound to a table that
have 4 bit values (linked from SQL Server). When I click on the Field list
and drag them to the form, these fields become textboxes (not bit). Why? How
can I create checkboxes in Access form with the bit values. Thanks for your
help.
 
J

Jeff Boyce

Tim

This newsgroup (tablesdbdesign) is dedicated to supporting the design of
tables. Your question seems to be form-related.

In the future, you'll get more eyes on your question if you post to the
newsgroup supporting your question.

If you are saying that you have a table that has 4 fields, each a "bit"
type, one way to do this would be to first create a query to return only
those fields you need for the form. Then, from the query (rather than
directly from the table), you can highlight the field, then click on/drag
the checkbox tool in the toolbox bar. This should put a checkbox on the
form for the field selected.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access checkbox and SQL Server bit 1
Convert Values to Checkboxes in Table 4
Access MS Access Listbox not saving to bound field 0
Unbound Data Entry Form 5
Creating Checkbox Fields For Every Record 0
Checkbox issue - Checkbox overlapping when filter is applied 1
table/form design question 3
Translate Checkboxes to a Table 6

Top