vanishing yes/no boxes

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

Guest

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