Form resizes on restore of access application window?

[bluecjh]

My 'maximized' form resizes on restore of access application window?

If I minimize access window and then restore it
the previously maximized form loses it's maximized state.
This looks sloppy, how can I stop this from happening

Thanks for any help.

 

[timotai]

How about adding this to the code of the form?

Let me know if it works.

Private Sub Form_Activate()
DoCmd.Maximize
End Sub

 

[bluecjh]

I already have this in place, to no avail.
thanks

 

[PHV]

Is a modal form an option ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[bluecjh]

PHV,
Making the form modal makes no difference.
chris.

 

[stevemaxwellimp]

I would love to know a neat solution to this one.

As a temporary solution I place a button (that is visible in restore mode) on the form and run docmd.maximize from this button.

 

[bluecjh]

I will try this, does this mean I'm not the only one
whose baffled?

It is odd because in my db the 'startup' form does not
become 'un-minimized' when the application is minimized,
whereas the next form opened from the start-up form
has this problem.

i.e. when the start-up form is restored it does not require to be maximized, but I can't see why the 2 forms behave
differently.

I tried creating a new database with 2 empty forms, one
as startup and the issue is there for both?
thanks steve

 

[dRahme]

Hi, this might help. If I minimize a form because I want to preview a report I minimize it using the button click that activates the report.

In the report's onClose event I have two lines:

DoCmd.OpenForm "TheForm", acNormal
DoCmd.Maximize

I imagine the same would work for forms as well.

 

[bluecjh]

dRahme, My problem relates to the restoring of the access
application window.

OK I have a fix after much thinking.

If a form has focus and the Access application
is then minimized. Then it is restored the only
form event that occurs is the 'resize' event.

A docmd.maximize won't work here,
but if you set the form.timerinterval = 30 (say)
in the resize event.

Then in the 'Form_Timer' event put:

    DoCmd.Maximize
    Me.TimerInterval = Empty

Voila.

Do I get a point?