Reports from check boxes on a form

[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?

 

[Larry]

-----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

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]

how do i design a report to list only the information in
check boxes that were checked in one field.

-----Original Message-----

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

 

[Jeff Boyce]

Tracy

I'm somewhat confused. Do you want your report to display the fieldnames of
those "checked" on the form, or the contents of the fields whose name(s)
were "checked"?

If the former, I'm not clear on the context/business need to know
fieldnames...

If the latter, it sounds like you're trying to create, dynamically, a report
that could have any number of fields -- how would this dynamically-created
report know which order to put the fields in?

More info, please...

Jeff Boyce
<Access MVP>

 

[Ed]

Sounds like you want to print some items chosen from a list not form items
You may need a subform on your form with a list of items to choose.
as you scroll through the list you want to check the items that you need and
have a report print listing check items. is this right?

 

[Jeff Boyce]

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>

 

[Ed]

Posted an access 2002 test database at www.plymouthharbor.com
Need to download and extract file to test.
Is this what your thinking?
Ed

 

[Tracy]

Yes- that is exactly what I'm trying to do with about 8
checkboxes to list into one textfield on a report if
possible.

 

[Tracy]

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