|
||||||
|
Hide With Macro By Richard Rost 17 months ago 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
Links
Recommended Courses
Keywordsaccess 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
|
||||||||||||||||
| |||
Keywords: TechHelp Access hide field with macro, visible property, setproperty, if then block PermaLink Hide Field With Macro in Microsoft Access Report |