check box into a text field on a report

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
.

Relevant Pages

  • Re: Count records in a report
    ... Since checkboxes are usually tied to a yes/no field they always have a ... The trick here is to account for the field always having a value (-1 ... Report when a check box is ticked ...
    (microsoft.public.access.reports)
  • Re: check box into a text field on a report
    ... i have a table with 12 checkboxes for different type of products, ... basically user has to tick if this product applies to the entered ... i have the same group of boxes in my report which i want ...
    (comp.databases.ms-access)
  • Re: check box into a text field on a report
    ... account. ... i have the same group of boxes in my report which i want ... I'd probably drag all 12 checkboxes to the report and set their visible ...
    (comp.databases.ms-access)
  • Re: Shifting textboxes on report after hidden
    ... Are all of these in the same report ... section of the report and these textboxes are located in the "Exercise ... This is the code I am using for the checkboxes, ... Dim ctl as Control ...
    (microsoft.public.access.reports)
  • Re: Shifting textboxes on report after hidden
    ... Are all of these in the same report ... section of the report and these textboxes are located in the "Exercise ... This is the code I am using for the checkboxes, ... Dim ctl as Control ...
    (microsoft.public.access.reports)