Yes / No Field

[Gary Nelson]

In Access2000, I have a table that was previously created. (I have a two
part question).

First, I am being asked to create a field which would determine whether or
not we have an item in inventory by adding a yes/no check box on the main
table. I have added the yes/no inventory field, however on the report, it
is showing as a "0" or "-1" instead of yes/no. How can I change it?

Second, when I return to the main table to make a change, I receive a
message box when I try to go into design view. The message box reads, "You
can't open the table for modification, etc..... Why?

 

[Fredg]

Gary,
What does this have to do with the Queries newsgroup?

In place of the actual check box field, add an unbound text control to the
report.
Set it's control source to the Check Box field.
Set it's format property to:
;"Yes";"No"

As far as your error message is concerned,
If the table is in use by an open form, you cannot modify it.
Close the open form.

If the table is a linked table, you cannot modify it.
Navigate to the database that contains the table.
Modify it there.