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]
 
Back
Top