Check Box Problem with Make Table Query

[Kathy Krizl]

I'm probably doing something stupid, but I have a make table query.
One of the tables I reference has some check box fields in it. Their
Data Type is Yes/No, their field property format is Yes/No, they have
no default value, and their Display Control is Check Box. When I run
my make table query, the new fields have a Yes/No Data Type, but the
field property format comes up blank, and the Display Control comes up
as Text Box. How come all of the properties aren't coming over with
the make table query? I tried setting them manually, but when I run
it again, and the table gets deleted before it gets made again, the
properties go away. Any ideas?

[MacDermott]

Design details like that will not be transferred by a Make Table Query.
Do you really need to re-make the table every time?
It's often more convenient to use a Delete Query to remove all data from
your table, then an Append Query to put the new data in.
Note that with a MakeTable Query, you lose all your indexing as well -
including your primary key!

HTH
- Turtle

"Kathy Krizl" <kk****@co.el-dorado.ca.us> wrote in message
news:7f**************************@posting.google.c om...

I'm probably doing something stupid, but I have a make table query.
One of the tables I reference has some check box fields in it. Their
Data Type is Yes/No, their field property format is Yes/No, they have
no default value, and their Display Control is Check Box. When I run
my make table query, the new fields have a Yes/No Data Type, but the
field property format comes up blank, and the Display Control comes up
as Text Box. How come all of the properties aren't coming over with
the make table query? I tried setting them manually, but when I run
it again, and the table gets deleted before it gets made again, the
properties go away. Any ideas?

[Kathy Krizl]

Delete and append is perfect. Thanks!!
"MacDermott" <ma********@nospam.com> wrote in message news:<TX***************@newsread3.news.atl.earthli nk.net>...

Design details like that will not be transferred by a Make Table Query.
Do you really need to re-make the table every time?
It's often more convenient to use a Delete Query to remove all data from
your table, then an Append Query to put the new data in.
Note that with a MakeTable Query, you lose all your indexing as well -
including your primary key!

HTH
- Turtle

"Kathy Krizl" <kk****@co.el-dorado.ca.us> wrote in message
news:7f**************************@posting.google.c om...

I'm probably doing something stupid, but I have a make table query.
One of the tables I reference has some check box fields in it. Their
Data Type is Yes/No, their field property format is Yes/No, they have
no default value, and their Display Control is Check Box. When I run
my make table query, the new fields have a Yes/No Data Type, but the
field property format comes up blank, and the Display Control comes up
as Text Box. How come all of the properties aren't coming over with
the make table query? I tried setting them manually, but when I run
it again, and the table gets deleted before it gets made again, the
properties go away. Any ideas?