Help with module to set report/form toolbars

[JackieEVSC]

I needed to remove the ribbon from all forms and display the ribbon on all reports. I was able to create a (time-consuming) workaround by adding code to every form (on activate) and every report (on activate and on deactivate) to display/hide the ribbon. I had to do this for 21 forms and 48 reports. I was in a crunch and was okay doing this one time, but I don't want to have to do this every time I send out a new frontend to users.


Someone on here suggested I make this a function and pass the form/report name to a standard module. I have had no training in vba. I can generally take someone else's code and tweak it to fit my needs, but I don't know enough to write it on my own. Can someone help me or point me to a resource that can show me how to code such a module? Thanks.

[ItsMe]

You want to hide the Ribbon for forms but not for reports? It only takes one line of code to hide the Ribbon. What is it that you believe you need to place into a function? Are you looking for a way to monitor OnActivate and OnDeactivate for all open Forms and Reports? I suspect the only way to do this is to create a Custom Class as a Factory for your forms and reports. Then a specific menu would use the class to open forms and Reports.

Seems like a lot of work when the conventional approach would be to always hide the Ribbon or create custom ribbons using XML.