How do you resize a popup box upon trigger?

[JGalletta]

I have a popup box containing a button that, when pressed, adds/removes a few fields to the popup. When this happens, the buttons are moved down to provide space for the additional fields, and are no longer visible - you'd have to scroll or re-size the box to be able to see them. Is there a way to simply increase the popup height (re-size it) to the current height +/- 1000?

 

[John Big Booty]

Have a look at the MoveSize Method.

Another method would be to put your Buttons on the Form Footer, in which case the Buttons will always remain visible regardless of what happens in the body of the form.

 

[vbaInet]

Another method would be to put your Buttons on the Form Footer, in which case the Buttons will always remain visible regardless of what happens in the body of the form.

Definitely the more sensible way to go.

 

[JGalletta]

Works great, thanks!