Make tabel query does not show check box

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

Guest

I want to take an existing table and make a new table from it with some of
the records removed. I am able to make the new table with the records
removed but one of the fields in the original table is a check box field
which I want to remain a check box in the new table. The new table, however,
does not show that field as a check box even though the the format in
datasheet view for that field shows "yes/no". The check box field is shown
as "-1" in the new table.
 
Just curious, why are you making a new table by removing items from an
existing table? Sounds like you are going to end up with duplicate data in
your database. Anything you want to do from a table, you can generally do
from a query. If your plan is to use this filtered data as a source for a
form, report, other query, etc. then you do not need to make a new table,
just use the query as your record source.

Sounds like you might be going down a really bad path.
 
Thanks Rick B. for the "brain jog". I am new to Access but all I could think
of after reading your post was "I knew that"!
 
Just for you info.: -1 represents True which is a valid value for Boolean
Fields (there is no "CheckBox" Field and CheckBox is a Control).

If you want to show a Boolean Field using CheckBox, open the Table in
DesignView, select the Boolean Field in the top pane, click the "Lookup" tab
in the lower left pane and then select CheckBox as the Display Control.
 
Back
Top