Resizing Controls when Form Resizes

[UncleCake]

Hi,

I need to resize controls in a form when it is resized, which I have never done. I have searched for other help and tutorials, but I haven't found much.

My over all goals are to have the form size proportionally only and have the controls fit within the form. My biggest culprit is a large spread sheet control displaying lots of data.

Is this possible?

-Uncle Cake

 

[TGandon]

You need to place some code in the Form_Resize event
e.g.

Private Sub Form_Resize()

   'This keeps the command button in the horizontal centre of the form
   'and 1100 from the bottom
   cmdOK.Left = (me.Width - cmdOK.Width) / 2
   cmdOK.Top = Me.Height - 1100

End Sub

Trevor

 

[shakespeare5677]

You could also use the move method which, depending on what is being resized may keep things smoother on the eye. The code is myControl.Move sngLeft, sngTop, sngWidth, sngHeight. You don't have to enter all the arguments since they are all optional.
-Max

 

[BobRodes]

<depending on what is being resized may keep things smoother on the eye.

Interesting tip, Max. I've never really used the Move method, just resetting properties instead. I'll have to try it.

Also, I generally use ScaleWidth and ScaleHeight, which are the usable height and width of the form.

Bob