Form To Fit Access Window Height

[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.

 

[Jeff Conrad]

This code should fit the bill just fine.
It will fill make the form fill the entire area you just described.
I use it all the time:

http://www.mvps.org/access/api/api0022.htm

 

[Eli]

Hi Jeff, thanks for the tip.

I found some other stuff on that same site that I'm playing around with.

Thanks again.

--

Eli
NewWorld Micro

This code should fit the bill just fine.
It will fill make the form fill the entire area you just described.
I use it all the time:

http://www.mvps.org/access/api/api0022.htm

 

[Jeff Conrad]

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>