Displaying a field based on a checkbox

[Eric G]

Hi, Here is my problem. I have a checkbox with 5 options. Call them check1,2,3,4,5. and the field itself checkbox_Checklist. Now depending on which checkbox is selected I want to display a second field. So say check1 is selected I want Check1field to display and also want the check1field to display the number 1. So would this be IF (checkbox_Checklist = "check1";"1";"")? Because I have tried that and it didnt work. Any help is appreciated.

Thank You,

Eric G.

[Inky Phil]

Have a look at the Case() function.

It goes something like this

Case(condition1;result1;condition2;result2;default result)

You can have as many conditions/results as you like and the calc will keep going til it finds one that works.

If it doesn't find one it will use the default result so by using "" as the default you can efectively make a field 'disappear'

HTH

Phil

Edited February 6, 2007 by Guest

[Eric G]

Hi Phil thanks for the advice. I had tried using case but maybe I am doing it wrong.

Case(checkbox_Checklist="checkbox1";"1";"checkbox_Checklist=""";"")

I am guessing this means that if Checkbox1 is selected it will display a 1 and if Checkbox1 is deslected it will display nothing/Null. However when I implement this it does return a value of 1 when selected but that value stays when Checkbox 1 is deselected.

Thank You,

Eric G.

[Lee Smith]

You have too many conditions I think. Try something like

Case ( CheckboxList = 1 ; 1)

HTH

Lee

Edited February 6, 2007 by Guest

[Raybaudi]

Hi

...or this:

Case(

PatternCount( checkbox_Checklist ;check1 ) ; 1 ;

""

)