Show or Hide Controls in a Report Using a Macro

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?

Prerequisites

• Invoicing: https://599cd.com/Invoicing

Links

• Intro to VBA: https://599cd.com/IntroVBA

Recommended Courses

• Access Advanced Courses: https://599cd.com/Advanced

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

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