JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
The problem is when this application is closed and a different Access database loads, the Ribbon remain Minimized; I need it Maximized.
The following code does not work.
if RibbonIsMinimised = Application.CommandBars("Ribbon").Height < 100 then CommandBars.ExecuteMso "MinimizeRibbon"
On my pc 79 is the Minimized ribbon height and 159 when Maximized; hence I chose 100 !!
I have tried the above but it doesn't work. I tried a few things and I found the following:
On my PC Ribbon Minimized height = 97 en Maximized = 190
Code: If Application.CommandBars ("Ribbon"). Height <120 Then CommandBars.ExecuteMso "MinimizeRibbon"
I placed the code in the report load and it worked perfectly!
