Form opening gigantic!

  • Thread starter Thread starter BrookieOU
  • Start date Start date
B

BrookieOU

When I open a form from my switchboard it opens the form huge...where I can't
even see the min/max buttons without dragging the screen. Is there anyway to
resize the form so it will open correctly from the switchboard?
 
To ensure that it is exactly the size I want, I use a subroutine that I put
in a code module.

Then, in the forms Load event, I call this subroutine and pass it the height
and width (in inches).

Call SizeForm(4.5, 8.5)


Public Sub SizeForm(FormHeight As Double, FormWidth As Double)

Dim frm As Form

Set frm = Forms(Forms.Count - 1)

frm.InsideHeight = FormHeight * 1440
frm.InsideWidth = FormWidth * 1440
DoCmd.Restore

End Sub
 
You have a bunch of choices. Here are a few:

1. Open up the Switchboard form in design view. Resize it what way you want.
Save the changes. It should then open up at that size.

2. Put the following in the Open event of the Switchboard form:
Docmd. Maximize
2.a. In the Close event put:
Docmd.Restore
2.b. This could have the unintended consequence of making all the forms show
up as Maximized.

3. Use the MoveSize function on the Open event of the form. You can put the
form in a specific place on the screen with a set size. Try this for starters
and adjust form there.

DoCmd.MoveSize 1000, 1000, 6000, 6000
 
Back
Top