How do I convert checkbox data into text description?

[bricklebrit]

Hello,

When generating a report, I have a check box true/false value for the item [Sampler].

When I generate my report, instead of shows the checkbox next to the item [Sampler]. If the checkbox is true, I want to generate a text line reading "I've included the sampler in your package". If the checkbox is false, I can just skip over it.

Could anybody out there tell me how to set up a simple script to do this?

Thanks in advance for you assistance!
Jon

 

[JohnLowell]

you need to code an iif statement for the control source of the text box:

=iif([check box field name] = -1, "I've included the sampler in your package","&quot

 

[bricklebrit]

Hi John,

Thanks for the prompt response -- it works great!!

On the same report, I'm trying to develop a code that says the number of CDs based off the value [NumCD].

If its just one CD, it should read 'this CD'
If its more than 1 CD, I should say 'these ___ CDs'

Based of the code you've given me, I've coded this out, the syntax if definately wrong and I can't seem to get through it:

=iff((Sum[NumCD]) > 1 ,"these " & (Sum[NumCD]) & " CDs","this cd&quot

Thanks for any insight you might have and thanks again for all the help!
Jon

 

[JohnLowell]

Try this:

=iif((Sum[NumCD]) > 1 ,"these " & (Sum[NumCD]) & " CDs","this cd&quot

You will have to use this in a footer to get the Sum. If you don't, you will just det the sum of the detail.

 

[bricklebrit]

Hi John,

I'm trying out:

=iif((Sum[NumCD]) > 1 ,"these " & (Sum[NumCD]) & " CDs","this cd&quot

I'm actually get a sytax error claiming that I've 'entered an operand without an operator' -- any ideas?

Thanks,
Jon