How to create checkbox in make table query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can someone please shed some light on this problem which has me squared-eyed!

How can I create a checkbox using a make-table query? When I make the table
I get Yes/No data type but it doesn't seem possible to set the format and
choose the Display Control.

How do I sort this?

Thanks.
 
Can someone please shed some light on this problem which has me squared-eyed!

How can I create a checkbox using a make-table query? When I make the table
I get Yes/No data type but it doesn't seem possible to set the format and
choose the Display Control.

How do I sort this?

Thanks.
Click to expand...

You can't, and there should be no reason why you would want to.

Table datasheets should not be used for data entry or viewing. They're
for debugging. Use a Form to view your data.

For that matter, MakeTable queries are VERY rarely actually necessary;
if you want to look at a subset of the data in your table, or at data
from two or more linked tables, you can create a Query to do so; you
can base a Form, a Report, an export, even a datasheet on this Query.
You gain nothing by creating a new table.

John W. Vinson[MVP]
 
You must log in or register to reply here.

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

Filter query with checkboxes 0
Make table query: [Enter 1] AS Test 1
Make-table query with around 2 ml records taking too long 0
Query of checkboxes. 5
Creating Checkbox Fields For Every Record 0
Make Table Query with path Parameter 1
make-table 1
adding a field in a make table query 5

Back
Top