Reports from check boxes on a form

  • Thread starter Thread starter Tracy
  • Start date Start date
T

Tracy

I have a form with check boxes for selecting one or many
items. I want to create a report that will have a field
to list the field names of the items that were checked.
So if someone checks 2 items it would list them both and
not just the yes/no feature of the check box. Is this
possible and if so how?
 
-----Original Message-----
I have a form with check boxes for selecting one or many
items. I want to create a report that will have a field
to list the field names of the items that were checked.
So if someone checks 2 items it would list them both and
not just the yes/no feature of the check box. Is this
possible and if so how?
.
place the check box on the form and use the following in
Click to expand...
the property data tab for control source
=IIf([CkBoxName]=0,"What you want if checked","What you
want if box is not checked")
Use "" if you want blank is not checked
the 0 means the ckbox is checked.
 
Tracy

Let's try an example to see if I get it...

Bill checks the following checkboxes: "Contact me by email" & "Send
Birthday card"
Jill checks: "Contact me by phone" & "Send Anniversary card"

You want a report that lists:

Bill
Contact me by email
Send Birthday card

Jill
Contact me by phone
Send Anniversary card

Or am I still confused about what you're trying to accomplish?

Jeff Boyce
<Access MVP>
 
Yes- that is exactly what I'm trying to do with about 8
checkboxes to list into one textfield on a report if
possible.
 
That doesn't look like what I'm trying to do - the
explanation Jeff Boyce gave is right. I tried to put up
a sample database on my site but I don't know if I did it
correctly for you to be able to view it.
www.cceda.org/test.htm
 
Back
Top