Help with Check box and text

  • Thread starter Thread starter AmandaH
  • Start date Start date
A

AmandaH

I am use to using Lotus - 123. What I would like to do with my access
database is two things.

First:
I have 3 check boxes "Aboriginal", "Francophone" and "Women"; they are
linked to the table through a control source. Now in Lotus when I check
"Francophone" (for example) Francophone shows up in the column under
that record in the table, in Access I see a -1. How to I change this to
work as lotus does?

Second:
I already have 400 records in the table that I am linking to, when I
pull up a record if the person is a Francophone I would like the
Francophone check box to be checked. How do I do this?

Lotus makes this really easy and I am thinking/hopping that there is an
easy way to do this in Access.

Thanks,

~Amanda~
 
Open your table in Design mode. Put your curser in the yes/no fields you are
concerned with. On the bottom of the screen you will see the attributes of
that field, There is a second tab labeled lookup that needs to have check
box selected.
 
I found that, but that just changes all of my tect in my table to check
boxs, so I lose all of the information for the 400 records. What would
be ideal is if I could use the Form to see the check box(checked or
unchecked) depding on the respons to the question. In the table it
would still say " Aboriginal", "Francophone" and/or "Women".
 
I found that, but that just changes all of my tect in my table to check
boxs, so I lose all of the information for the 400 records. What would
be ideal is if I could use the Form to see the check box(checked or
unchecked) depding on the respons to the question. In the table it
would still say " Aboriginal", "Francophone" and/or "Women".
Click to expand...

Access isn't Lotus 123. It's not even "Microsoft Excel on steroids," though
some would like it to be. :-)

Check boxes are for displaying Yes/No information, so you'd need to do some
manipulation to make them work the way you describe. A calculated Field in
the Query that you use for the RecordSource of your Form, like

AboChk: IIF ([fn] = "Aborignal", True, False)

and then use AboChk as the Control Source of the CheckBox with the label
"Aboriginal".

Larry Linson
Microsoft Access MVP
 
Back
Top