Re: check box into a text field on a report

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
.

Relevant Pages

  • 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)
  • Re: How to use a "For Each...Next Statement using an array in a report
    ... John Nurick wrote: ... I need to use it in a report and I need to use an array. ... list only project names and their associated labels ... - The above code is repeated for all my 75 checkboxes. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Formatting at Runtime
    ... The report has 2 Groupings. ... The Group Header for Name is empty but I have a calculated field and a series of checkboxes in the Group Header for Level. ... What I want to do is turn the Visible property for some of the boxes to True based on the value of the calculated field (ie., if the Calculated field value is 4 I want the first 4 Checkboxes to be visible. ...
    (microsoft.public.access.reports)
  • Re: Elegancy instead of brute force in selection of data.
    ... In the form, the ColorName field is a combo box, and the RowSource is the ... subform bound to the PersonColor table. ... Creating report based on a single table. ... > field for a name and 25 fields that are all Yes/No checkboxes. ...
    (microsoft.public.access.reports)