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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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)
 
THanks for your help Dennis, I managed it using the first option slightly
reworked.

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

Thank you my friend.
 
Back
Top