Dear all
Need help for the way to hide the text box when the ünbound field is Zero
I am making a voucher for my client who has selected few items in a conference.
I have to prepare a voucher for everyone in a summary what they booked, i.e the field with "1"
Please kindly help, it bother me for a while, as i try Can Shrink for the Unbound box but the textbox cannot be removed
ThanksDatabase101.accdb
I get some information on website
https://answers.microsoft.com/en-us/...1-c6ee0be8b36d
But i do not understand where to put it ( i am new to ACCESS)
=IIf(IsNull([YourMemoFieldName]),Null,"Label Caption Value")
The expression should be placed in the control source of a text box that replaces a label control.
Please consider your report will have Label and text box controls. They both have a "name" property. The label control has a Caption property and a text box has a Control Source property.
Really appreciated help, i did try due to my limited knowledge , please help