Converting check boxes to text

  • Thread starter Thread starter Mike Monville
  • Start date Start date
M

Mike Monville

I have an artist member table that lists different media that a given member
works in. These are in the form of yes/no check boxes in the table. I want
to be able to convert a yes in any check box to print the name of the media
(field name) on a report. Any help is appreciated. (Access 2000)

Thanks - Mike
 
Just use an unbound textbox with an IF statement.

If the "pastels" box is true, then display "Pastels" otherwise, display "".
 
I have an artist member table that lists different media that a given member
works in. These are in the form of yes/no check boxes in the table. I want
to be able to convert a yes in any check box to print the name of the media
(field name) on a report. Any help is appreciated. (Access 2000)

Thanks - Mike
Click to expand...

Instead of the check box in the report, add an unbound text control.
Set it's control source to the check box field.
As the control's Format property, write:
;"Watercolor";

Repeat for each check box field.

If the check box is yes it will print the media name. If No then the
control will be blank.
 
This works great, but I think I have too many categories to make this
workable. I have 50 possible checkboxes, of which most members would only
have one to three, but some have as many as twelve. Also, how would I be
able to put those fields together for output on one line instead of
retaining their relative placement in the detail section? eg: a checked
acrylic box and one checked in watercolor results in all the empty fields in
between printing as white space.

I have the feeling that I should have put this info into a separate table.
Is it too late to do that without jumping thru too many hoops?

Mike
 
Back
Top