Prevent ribbon from showing when datasheet subform has the focus in Access 2010
Posted on 2011-05-03
I'm experiencing an annoying problem in Access 2010. This doesn't appear to be happening in 2007. In my application I hide the ribbon at startup. The only time I want to see a ribbon is when i run reports and those are custom ribbons. all this works great except in 2010. If I have a main form with a datasheet subform, then the app displays a default ribbon when the subform has the focus. This causes the entire window to shift down. when the main form loads the ribbon is minimized, but if I run code to change the record source of the subform then the focus goes to the first record of the subform, a ribbon is maximized and the window shifts down to accomodate it.