Check Box & E-Mailing a Report. HHHEEELLLLP!!!

[Guest]

In Access help, it says that e-mailing a report it will not give any info. that is a Check Box or Option Buttons ( it sends the text box but not the check mark). So, what can I do and how if I must have that info

Thank you,

 

[Rick B]

Don't use a check box. Use a textbox with contents like...

=IIf([CheckBoxField),"Yes","No")


Rick Bear


In Access help, it says that e-mailing a report it will not give any info.
that is a Check Box or Option Buttons ( it sends the text box but not the
check mark). So, what can I do and how if I must have that info.

Thank you,

 

[Rick B]

make that...

=IIf([CheckBoxField],"Yes","No")





Don't use a check box. Use a textbox with contents like...

=IIf([CheckBoxField),"Yes","No")


Rick Bear


In Access help, it says that e-mailing a report it will not give any info.
that is a Check Box or Option Buttons ( it sends the text box but not the
check mark). So, what can I do and how if I must have that info.

Thank you,

 

[Guest]

where this code should go

Thanks,

 

[Guest]

I tried but it not working. Would you please give me more detail on how to do it

Thanks,

 

[Rick B]

Just create a text box and put an 'if' statement in it similar to the one I
gave you in the previous example. Replace [CheckBoxField] with the name of
your field that you wish to evaluate. For more info, look at the Access
help file on how to build an IIF statement.

The basic format is...

IIf(condition,true case,false case)


Rick
I tried but it not working. Would you please give me more detail on how to
do it?

Thanks,