Form Maximize

[NigelShaw]

Hi Guys

odd question. I am maximizing my form onLoad and the top 20mm is under the ribbon. I dont want to maximize the application window and want it to open at the same size every time so how do i do this? I can get either

fill the screen with top under ribbon
form not maximized and it moves around ( with a mouse grab ) wuth the app window

im using doCmd.Maximize

Cheers

Nigel

 

[Trevor G]

Nigel you need to change the docmd.maximise to a MoveSize

You can either use a macro or can use VBA.

Macro is as easy as the VBA and you can convert to VBA with Error Handler if needed.

Sample of converted macro is shown below

DoCmd.MoveSize 567, 567, 7371, 7371


In the Macro window I set:

Right 1cm
Down 1cm
Width 13cm
Height 13cm

 

[NigelShaw]

Hi,

not its not what i am looking for.

in database 1, i have a form that opens like this-

with the same form settings in a different db,

furthermore, on the 2nd image, i actually have a further 20mm above this line with buttons button cannot see them because the form doesnt seem to open properly.


any ideas?


thanks

nigel

 

[NigelShaw]

Hi,

and now, this-

there are images above the text that are under the ribbon. How can i get it to stop at the ribbon bottom edge?


Cheers

N

 

[boblarson]

Hi,

and now, this-

there are images above the text that are under the ribbon. How can i get it to stop at the ribbon bottom edge?


Cheers

N

Sounds like you're going to need to run in Tabbed Document mode (you can select no tabs as an option) but then it should open full to the Ribbon and not beyond as long as it isn't set to POPUP.