VBA Maximize Access Application Main Window
I've spend a while battling with this problem too, reading various blogs and posts. I've found a very simple way to achieve the desired outcome in VBA using just one line of code. In the VBA editor, place this code AFTER your On Load code:

[Your On Load code] 

KeyCode = 16

This code achieves the equivalent of pressing F11, ie maximising the view of the currently open window.