check box into a text field on a report

[Mike]

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

[Salad]

Mike wrote:

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

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

[Mike]

On Feb 28, 5:08*pm, Salad <[e-mail]:

Mike wrote:

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

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.

Beatleshttp://www.youtube.com/watch?v=-jIEGZwLPvo- Hide quoted text -

- Show quoted text -

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