Scroll bars dissapear when I use DoCmd.Maximize On Open Event - Ms Access

Question

Hi there,

I'm using DoCmd.Maximize On the Open event of a "split-form", so that it the form fills the screen when opened.

Unfortunately, this seems to remove the scroll bars for the form, which I have set in the form's properties. There is a requirement for the scrolls as info does extend beyond the screens real estate. Cant seem to find a solution anywhere to this problem, is there an alternative to maximising the form to fill the screen?

Any help greatley appreciated

Cheers

Noel

Answer 1

Scroll bars do not appear when the form is large enough to display all its contents. (The screen area for the scroll bars is still reserved, however, which you can see if you play with the colors.)