Open Forms to Full Size

[akaivyleaf]

I want all of my forms to open to Full Size. Instead they move all over the place.

I have a switchboard that opens to full size the first time it is clicked on. When it opens other forms, they open to various sizes, even though they were created the exact same way the switchboard was. When the other forms, return the user to the switchboard, it has inched down a bit so there is a gap at the top.

I have removed the min/max/close buttons, I have removed the horizontal and vertical scroll but still no luck.

Any suggestions? I have to present this database on Monday and cannot for the life of me fix this problem.


Sharon

 

[ghubbell]

Hi Sharon,
You'll have to add a line to your forms "Visual Basic" module and here's how:
Open your form in design view. Double-click on the little black square in the top left corner of the view. This will open a dialog that shows the forms "properties". Select the "Event" tab. Look for the event called "On Load". Click once on this field and you'll see an arrow down button. Select "Event Procedure". Now you'll notice another button just to its right: "..." clicking on this button will open up your forms visual basic module, and label a procedure with a heading and an "end sub". Between the heading and the "end sub" type:

OnErrorResumeNext
DoCmd.Maximize

Close and save everything. Now open your form!

Gord
ghubbell@total.net

 

[Arcadi]

The mest thing would be to create a macro with one command in it- maximize, then put that macro in the on open properties of all the forms that you want to open full screen.

 

[akaivyleaf]

You all are so wonderful. . . I guess I am just brain dead and things aren't working the way I want them to because I am stressed.

It works now, thanks.