Re: check box into a text field on a report

On Feb 28, 5:08 pm, Salad <o...@xxxxxxxxxxx> wrote:
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
.

Relevant Pages

  • Re: Multiple Checkboxes in Search by Form
    ... from checkboxes to a multi-select list box can I also make that change in my ... > build up the WhereCondition string to open a report, ... If none of the boxes are checked, ... > Dim strWhere As String ...
    (microsoft.public.access.queries)
  • Re: Parameter query with multiple check boxes
    ... Does the report get the info from the query which gets info ... "Duane Hookom" wrote: ... assuming you have check boxes on your criteria form and the ...
    (microsoft.public.access.queries)
  • Re: room chart problems
    ... I would probably create an unbound report with text boxes or labels ... then setup a join query how do i then put the occupants of each room ...
    (microsoft.public.access.reports)
  • Re: Clear and Requery combo boxes
    ... Q1 - I would put the code to clear the combo boxes after the code that calls ... the report and before the code that makes form visible again. ... > The choices then generate a report based on the selection. ... > Exit Sub ...
    (microsoft.public.access.formscoding)
  • Re: room chart problems
    ... I have a report that has unbound boxes for each room, ... Is there a way that I can use the label name such as "N047A" as the ...
    (microsoft.public.access.reports)