How to Show or Hide Controls in a Microsoft Access Report Using a Macro (Without VBA)

In this Microsoft Access tutorial I'm going to teach you how to hide fields in a report based on the value of another field. For example if we're printing an invoice and the order is paid we're going to make a giant paid label show up and if not hide it. We will use a macro for this since some people either cannot or will not use VBA.
Henry from Bend, Oregon (a Gold Member) asks: I need to be able to hide certain fields in a report based on the value of another field. For example we do a lot with demographics and if someone is in a particular state then I need to hide certain questions from showing up. Unfortunately my employer has locked down the systems and refuses to let anyone use VBA in Microsoft Office. So is it possible to do this with a macro?
BECOME A MEMBER:
KZbin: / @599cd
or My Site: 599cd.com/THMe...
LEARN MORE:
599cd.com/Hide...
PREREQUISITES:
Invoicing: 599cd.com/Invo...
LINKS
Intro to VBA: 599cd.com/Intr...
RECOMMENDED COURSES:
Access Advanced Courses: 599cd.com/Adva...
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Cont...
Order Entry & Invoicing: 599cd.com/Invo...
More Access Templates: 599cd.com/Acce...
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
How to Use Access in 30 Minutes: 599cd.com/30Mi...
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/Tech...
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.o...
products.offic...
microsoft.com/...
KEYWORDS:
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, hide field with macro, visible property, setproperty, if then block
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[@replicaman9215]

This video is new, so I may never get a chance to say this and have it seen otherwise, but I appreciate your videos, Richard. Your style and approach is old-school (which as an 80s/90s kid I appreciate) but simultaneously current, relevant, and ever so applicable. I've fiddled around with Access in various jobs for years, to varying degrees of success, but somehow watching your videos puts all my experience in its proper place, clears up ancient-but-fundamental misunderstandings, and makes me wish I had your videos as a resource years ago. I would've saved myself a lot of banging-head-against-the-wall moments. You truly are an MVP, thank you.

[@599CD]

Thank you very much I really appreciate that

[@Jojosmith342]

Another excellent, valuable tutorial. All thumbs up to the most exceptional Access teacher Richard. This is what I have searched for. Thank you so much Richard for your valuable time to educate the world. 🙏

[@599CD]

Glad it was helpful!

[@josecandidosorianavalon3339]

Hi, Richard! 25 or more years ago, when I firstly dove into Access, I did not know a word about VBA. I started with Macros... But when I learnt how to transform Macros to VBA, that was my real beginning indeed! Never ever since then I went back to Macros, but it is a kind of beginning for newbies... Do you agree? Best regards and thanks for your videos, useful both for beginners and 'old people' alike...

[@Shadow.Dragon]

Jose, I did the same thing for Excel. I would turn on the macro recorder, do an action(s), and then look at the macro. I would then manually covert it over to VBA (this was before MS put in the auto-convert function.

[@599CD]

Yeah that's a great way to learn in either Word or Excel is to use the macro recorder and see what kinds of commands it writes. Unfortunately there is no macro recorder in Access. Even though you can convert macros over to VBA you can't have it record your steps like you can in Word or Excel. Once again Access is the red-headed stepchild of the family.

[@7ammoodi1]

Dear Richard, I appreciate your efforts in preparing these helpful videos to make things easier for all ACCESS users. I do have a case which I really need your help with please: I have a form (it is Projects Teams Form) this form's data is stored in a table called Teams data. What I need is to select a pre-defined employee using a combo box displaying all stored employees' records in another table named Human Resources Data. Once I select his ID from my combo box in the current form (Projects Teams Form), the name of this employee should be copied from Human Resources Data table and displayed automatically in the Projects Teams Form name field. I do have many other fields as well, but it is enough to clarify how to get the name value form another table. Thanks a lot for your time.

[@zvig1]

is there a way with macro to change form caption?

[@599CD]

599cd.com/ask

[@johnwatkins39]

I like using Macros, because i work on a military base and i use databases alot. The military systems dont allow VBA. Samething with Excel. The military uses ALOT of excel.

[@599CD]

Yeah the military and big corporations are pretty tough on locking down VBA

[@Tlawat-1]

I have seen the level 1 4 hours what can I learn more

[@599CD]

Huh?

[@Orandivictor]

How can someone disable bypass key when login

[@599CD]

It's possible but it requires a bunch of coding and I cover it in my security seminar: 599cd.com/SecuritySeminar