vanishing yes/no boxes

R

r. howell

I have a table that I have generated by a maketable query.

The underlying table has yes/no decision boxes.

The generated table, when I look at its design, claims to have yes/no
decision boxes. (ie. that's the property listed for the fields that I am
concerned about.

However, something seems to be missing, because in the query, these fields
are coming up as zeros and -1's and when I go to put them on the form I'm
not getting check boxes.

I understand that the data has been preserved, but how do I get check boxes
to show up on my form?

Thanks.
 
K

Klatuu

Open your form in design view
Put the check box controls on the form you need
Bind each checkbox to the field in the table it represents.
 
S

Sprinks

Your issue is a common one--a misunderstanding of table *fields* and form
*controls*. A the value of a Yes/No (or True/False) field is either 0
(False) or -1 (True). In Datasheet or Table view, it represents this value
as an unchecked or checked checkbox.

In Form view, the representation of this value depends on the type of
control which is bound to the field. A textbox will display either a -1 or a
0, while a checkbox *control* will display as either a checked or unchecked
box, respectively.

So, delete your textbox and add a checkbox bound to your field. If
necessary, choose View, Toolbox to display the choices of controls.

Hope that helps.
Sprinks
 
R

r. howell

Thanks. My difficulty was caused by the fact that normally, when I drag a
Yes/No field onto a form, Access automatically gives me a checkbox. I forgot
that I could make one manually.
 
Top