Problem with form resize

[mike-davies]

I've got a form and have set the border style to "sizable" and when the form/code is running I can change the size of the form by dragging the edge with the mouse, BUT, form.width and form.height do not change. Hence I cannot pick up any value for the new form size and recalulate control sizes.

The code I'm trying to use runs OK in VB version 5, but now I'm trying it with VBA in Access 2003 it doesn't work.

Where am I going wrong ? Where do I pick up the new Form or Window size from ?

 

[boblarson]

check out the DoCmd.MoveSize function

The code is:
DoCmd.MoveSize (

,[Down],[Width],[Height])

You can use one or more of the options and it is specified in TWIPS.​

 

[mike-davies]

Thanks, but where do you get the current form size from ?

It's not form.width and form.height because they don't change as the form is resized by dragging the form edge.

 

[boblarson]

In the form's resize event.

For a test - put this code in the form's resize event:

MsgBox "Height:" & Me.InsideHeight & vbCrLf & "Width:" & Me.InsideWidth

 

[cslauenwhite]

I had the same problems.... This worked great for me

http://www.developershandbook.com/Downloads/ADHResize.zip

everything you need is in their