Form sizing

[JonatABS]

How to I make sure that when I open the form up that im onlying seeing the form at which I designed the form on.

youknow when you are designing a form you can resize the design form box to see everything. If I go back to the from itself I see the form plus all the area around the form. I hoep to god you folks know what im talking about cuz otherwise im gonna look stupid.

Thanks

PM me if your wondering what the heck im talking about.

 

[ghudson]

Below is the code I use when I want to "force" the size of my forms in the forms onOpen event. The message box is a quick way to see (test) what size your form is when opening.

MsgBox "InsideHeight = " & InsideHeight & vbCrLf & vbLf & "InsideWidth = " & InsideWidth

InsideHeight = 4605
InsideWidth = 7950

The measurements are in twips. My settings above measure @ 8"w x 4.75"h.

HTH

 

[Peter D]

Try a

DoCmd.RunCommand acCmdSizeToFitForm

...from your form OnActivate event procedure.

Hope this helps,