By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,932 Members | 1,302 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,932 IT Pros & Developers. It's quick & easy.

check box into a text field on a report

P: n/a
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
Feb 28 '08 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
Feb 28 '08 #2

P: n/a
On Feb 28, 5:08*pm, Salad <o...@vinegar.comwrote:
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
Feb 29 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.