Microsoft Access 2016 Reports: Hide Empty Records Labels in your Access Reports

[@tfewald01]

I designed and taught (college & corporate) Access database for years. Retired 5 years ago and have forgotten SO much. Now trying to create a membership database for my church, and trying to remember what I need. This is very well explained. Thanks.

[@AndoSydney]

Been looking for the way to hide labels for quite a while now. Thankfully I came across this video of yours that quickly and thoroughly describes how best to do it. Thanks so much!!!

[@tutsecret499]

Here is the situation: I have a directory with 24 counties, some does not have mailing address, or fax, or the state, or the zipcode or something else, when this happens, it shows the gaps in the report. My directory has 2 columns each county from A to Z. And the gaps are killing me. If I export this report into word, I fix the problem by paragraph as 0 space and resolved, but I don't want people doing this manipulation steps. The report should be normal in access. I set shrink everywhere and does not resolve.

[@MissMiskarg]

Hi Kirt. Thanks a lot for this video. But I have to say that although it has helped me a lot with my reports, I still have an issue with the YES/NO fields, which seem not to work with this expression. Is there another one which can be used for that particular case?

[@LordBransty]

great video Kirt. God bless people like you! You keep me in a good job.

[@KirtKershaw]

Welcome 😊

[@satyabanukil779]

Sir, how can I hide a field in a report when the value is zero. Thnx and regards

[@satyabanukil779]

Sir, I have a report with a currency field. I want to make it invisible where the value is zero. Is it possible? Kindly help.

[@apupatra123]

Thank for the trick

[@ruhollahsayyah]

Beautifully explained, Thanks

[@KirtKershaw]

Thank you 😊

[@tammy.becker]

Thank you very much. I was beating a field to death trying to figure out how to make it show only when data was present. This allowed me to accomplish the task without losing my mind.

[@KirtKershaw]

Welcome 🙂

[@learnmore5490]

Thank you Kirt.

[@KirtKershaw]

Welcome 😊

[@ristantosky]

save my day! thanks sir

[@KirtKershaw]

Welcome 😊

[@fullybakedbear]

Im on Office 365 and i get a #Name? when I try this code.

[@markb246]

Thank you. Great solution...

[@KirtKershaw]

Welcome 😊

[@pauljuneau1896]

Very cool. Just what I was looking for.

[@KirtKershaw]

Glad to hear 🙂

[@ashokachangadan7674]

How can i hide if field value is 0

[@ashokachangadan7674]

Pls comment thanks

[@vashistfood]

@@ashokachangadan7674 use the value you want to test for in the IIF function's condition, instead of the "" blank used in the shown example. Cheers !

[@rikiwaho9148]

Thank you so much, exactly what I needed.

[@KirtKershaw]

Welcome 🙂

[@NouraYassin]

Big thumb up .. Thanks

[@KirtKershaw]

Welcome 😊