check box into a text field on a report

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Mike
    #1

    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
    Tags: None
    • Salad
      #2
      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

        Comment

        • Mike
          #3
          Re: check box into a text field on a report

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

            Comment

            Previous template Next
            Working...