Hi guys,

i have a table with 12 checkboxes for different type of products, so
basically user has to tick if this product applies to the entered
account. So, i have the same group of boxes in my report which i want
to modify in a way, that instead of the checkboxes i would have text
fields and instead of checkmarks i'd have numbers: so if Product1 box
is ckecked in the input form, the report should show 1 in the Product
1 text field of the report, if Product2 is ckecked, it should show 2
and so on.

Graphically it should be as follows:

Product1 Product2 Product3 Product4 ... Product12
1
2 12

So in this example we have Product 1,2 and 12 active.

Could you advise how i play around this issue?

Thanks

Mike wrote:

I'd probably drag all 12 checkboxes to the report and set their visible
property to False

Then create 12 textboxes and set the control source to
=IIF([Checkbox1],"1","")
and change the fieldname, number for the respective checkbox.

Beatles
http://www.youtube.com/watch?v=-jIEGZwLPvo

On Feb 28, 5:08*pm, Salad <o... (AT) vinegar (DOT) com> wrote:
Thanks Salad,

i'm going to try it, think i can make the unvisible boxes very small,
so they don't eat the space.

Cheers