Make form size maximized without using the Maximize method

[rockman]

I would like to create a form that completely occupies the workspace of the Access Application window but without using the maximize method.

I need something like this: DoCmd.MoveSize 0,0,?,?

But don't know how to find values for ? and ?. The situation is fairly complicated because 1 OR MORE commandbars may be present. Therefore, it is not enough to merely know the size of the Access Application window.

Thanks for any help,
Jeff

 

[Alexandre]

I believe the following is what you're looking after. It uses API to get a handle to the Access window, then does some calculations...
Credits are dued to Terry Kreft


Maximize Restored forms - Get rid from the close button on maximized forms

 

[rockman]

Thanks Alexande,

The GetClientRect API was just exactly what I needed!

Cheers,
Jeff

 

[doulostheou]

This code is great, but I'm encountering some errors. I have a form that opens automatically when the database opens. It also hides the toolbars, etc. I am left with a gray space, where the toolbar previously appeared. I have tested calling the function on open and on load with the same effect. Also, if the user resizes their access window, scrollbars are added which does not work well (the application was made to run small in the bottoom right corner and users frequently have to resize because the last time they used access they had it maximized). Any suggestions?