checkbox

[Tim]

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.

 

[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