Keeping a form maximized (Access 2000)

[Alan]

I have a form (frmFind) that I would like to keep maximized. In the
form load event I have a docmd.maximize which works fine. However
the user may go to the database window (or any other Access window)
and restore ('unmaximize') the window.

I would like frmFind to be remaximized when the user clicks on the
form (either directly or via the task bar or Alt-Tab).

I have tried putting the maximize command in the form activate event
but the form just maximizes and then restores. I have tried using
echo off and doevents but still no joy.

I'd prefer not to clear the Windows In Taskbar option.

Any ideas would be *most* gratefully received

TIA
Alan

 

[Lynn Trapp]

Put DoCmd.Maximize in the OnActivate event of your form.

 

[Alan]

Thanks Lynn for replying but as I indicated that doesn't seem to work
for me.

I'm still stuck I'm afraid.

 

[Alan]

Thanks Lynn for replying but as I indicated that doesn't seem to work
for me.

I'm still stuck I'm afraid.

 

[Alan]

Thanks Lynn for replying but as I indicated that doesn't seem to work
for me.

I'm still stuck I'm afraid.

 

[Lynn Trapp]

Do you have code in some other event of the form to restore the form?

 

[Alan]

No I don't - I just started a brand new form and added Docmd.Maximize
to form activate event - when I open the form it maximizes ok but when
I go to the database window, restore it and go back to the form it
maximizes and then restores.

 

[Lynn Trapp]

Well, I'm just as puzzled as you are then. If there isn't some code in
another event, like OnOpen, to restore the form, then I can't tell you,
without seeing the database what the problem might be. Does this happen to
other forms in your database? If you create a new database does it happen to
forms there?

 

[Alan]

Yes, if I create a brand new database it also happens.