How to hide the text box when the ünbound field is Zero

[Erictsang]

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

[aytee111]

Please be more specific - what is the name of the unbound field (I do not see one on your report), what is the name of the field to be hidden.

[Erictsang]

All the fields -

Country A
Country B
Graduate
Pass_A_28 Nov etc..


In the report, the field Country A is 1, then it shows in the report, the Country B is "0"should not shown
But the text box Country B _Label can not hide

Eric

[aytee111]

In the OnFormat event of the Detail section (click on the Detail line):

    If Me!CountryA = 0 Then
        Me!CountryA.Visible = False
    Else
        Me!CountryA.Visible = True
    End If
    
    If Me!CountryB = 0 Then
        Me!CountryB.Visible = False
    Else
        Me!CountryB.Visible = True
    End If

..etc...

[Erictsang]

it does work

[Erictsang]

Can you send me back the file ?



Did i did anything wrong?!

[aytee111]

It is in your first post - ? Is there something you don't understand?

[Erictsang]

i lost

I have placed your advise

If Me!CountryA = 0 Then
Me!CountryA.Visible = False
Else
Me!CountryA.Visible = True
End If

If Me!CountryB = 0 Then
Me!CountryB.Visible = False
Else
Me!CountryB.Visible = True
End If

into the on format under the Detail section

But the Country A text box and Country B Text box still shown even if this is 0

So, i wonder if you have post the same on my sample file and i can have a view

Eric

[aytee111]

It seems that if you double-click the report to open it, it does not work, but if you go to Print Preview then it works!

[Erictsang]

You are right

When it comes to print mode, it hide all
this is what i want

Thanks

[Erictsang]

aytee

Is there any difference between

Me!CountryA = 0 and Me.CountryA = 0

[aytee111]

Yes there is a difference. Google "bang vs dot".