Рет қаралды 5,469
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.