If tick box enabled, display text on report - how?

[Guest]

Hi I have a tick box in a form called Item_Complete, I want the words ITEM
COMPLETE to be displayed on a report which also displays the rest of the
fields on this report if this tick box is enabled. How do I achieve this?

 

[Guest]

Further to my last post, there should be no quotes around the word true

 

[Guest]

Put Text Boxes on your report where required and make the Source like this
=IIF([Item_Complete]=True,"ITEM COMPLETE","NOT COMPLETE")
Your Other boxes can be like
=IIF([Item_Complete]="True",[YourFieldtoBeDisplayed],NULL)

 

[Guest]

THanks for your help Dennis, I managed it using the first option slightly
reworked.

=IIF([ItemComplete]=True,"ITEM COMPLETE","")

Thank you my friend.