Problem with expressions in a report.

[Guest]

I'm trying to combine the following expressions. The end goal is for the
Program Printer text field to be blank if chkPrintedProgam is not checked. I
would appreciate any suggestions.

=IIf(Reports!rptATD!chkProgramPrinter=True,"Sponsor","TUSAFB")

=IIf(Reports!rptATD!chkPrintedProgram=True,"Yes.","No.")

 

[Guest]

In the control source of the field in the report, you van write

=IIf([chkProgramPrinter]=True,"Sponsor","TUSAFB")
=IIf([chkPrintedProgram]=True,"Yes.","No.")
==================================
But if you want it to be empty, then
=IIf([chkPrintedProgram]=True,"Yes.","")

 

[Guest]

Ofer,
Thanks for the info, but it didn't work. That returned a 0 in the Program
Printer field on the report. I think maybe I wasn't clear about what I want
it to do. My intention is that the Program Printer field on the report is
blank if the Printed Program field is No.
Thanks for your help.
Bullman

In the control source of the field in the report, you van write

=IIf([chkProgramPrinter]=True,"Sponsor","TUSAFB")
=IIf([chkPrintedProgram]=True,"Yes.","No.")
==================================
But if you want it to be empty, then
=IIf([chkPrintedProgram]=True,"Yes.","")
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck

I'm trying to combine the following expressions. The end goal is for the
Program Printer text field to be blank if chkPrintedProgam is not checked. I
would appreciate any suggestions.

=IIf(Reports!rptATD!chkProgramPrinter=True,"Sponsor","TUSAFB")

=IIf(Reports!rptATD!chkPrintedProgram=True,"Yes.","No.")

 

[Guest]

Did you try
=IIf(Nz([chkPrintedProgram],0)=True,"Yes.","")
In the control source o fthe Printer text field
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck

Ofer,
Thanks for the info, but it didn't work. That returned a 0 in the Program
Printer field on the report. I think maybe I wasn't clear about what I want
it to do. My intention is that the Program Printer field on the report is
blank if the Printed Program field is No.
Thanks for your help.
Bullman

In the control source of the field in the report, you van write

=IIf([chkProgramPrinter]=True,"Sponsor","TUSAFB")
=IIf([chkPrintedProgram]=True,"Yes.","No.")
==================================
But if you want it to be empty, then
=IIf([chkPrintedProgram]=True,"Yes.","")
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck

I'm trying to combine the following expressions. The end goal is for the
Program Printer text field to be blank if chkPrintedProgam is not checked. I
would appreciate any suggestions.

=IIf(Reports!rptATD!chkProgramPrinter=True,"Sponsor","TUSAFB")

=IIf(Reports!rptATD!chkPrintedProgram=True,"Yes.","No.")

 

[Guest]

I'm still not getting the desired result. It may be that I'm not
understanding your suggestions. I'm fairly new at this and I'm not all that
great with expressions. I do appreciate your help though.
Bullmann