How to maximize a form in Form view?

[Amit]

Hi,

I have a menu form which is the startup form for the
database, and it has the following properties:

Modal: No
Border Style: Sizable
Control Box: Yes

The problem I'm having is that when the form opens, it is
not the same size as the full screen. I can always
maximize it using the maximize button after it opens up,
but I would like it to open to the full-screen size by
default.

I've tried to make it full-screen size when in Design
view, and then saved it; and it is full-screen size when I
view it right afterwards in Form view, but when I open the
database to test it, the form isn't full-screen sized.
BTW, the MS Access application window is full-screen, so I
don't think that's the reason for this behavior.

Is there any way to fix this?
Using Windows XP and MS Access 2K.

Thanks!

-Amit

 

[Cheryl Fischer]

Amit,

In the Open Event of the form, insert the following VBA code:

DoCmd.Maximize


hth,

 

[Amit]

Cheryl,

Thanks. That worked!! Learned another neat trick today

-Amit