Form To Fit Access Window Height

  • Thread starter Thread starter Eli
  • Start date Start date
E

Eli

Hi, I need to find a way to adjust the height of my my startup form via code
so that it fits within the Access window regardless of the resolution of the
machine that runs the app.

Basically, I want the top of the form to start right below the
menubar/toolbar and stretch down to the very top of the status bar, and will
run along the left side of the screen. It's a rectangular form that will be
used as a menu of choices and will always remain on the left side of the
screen.

I'm thinking I need to put this code either in the form's Load() or Open()
events, but don't know what the code would be. I looked at WindowHeight and
InsideHeight, but couldn't put anything together with these. I'm thinking
there's something available via the Application object, but can't seem to
find it.

If anyone knows how to do this, I'd really appreciate the help.

Thanks in advance.
 
You're welcome Eli, glad I could help.
I really like that particular code.

You should find plenty of cool things on that site
to help in your Access projects.

If you need some more Access links, let me know.
I might have one or two other links.

<vvvvbg>
 
Back
Top