Resising form

[Lodewijk]

Is i possible to resize the form after the user hits a button?

I have a form which shows the contents of a table. With the button cmdNew a
new record cabn be added. At that time some more fields are shown to fill
in, so I want to form to become lager.

 

[Michel Walsh]

Hi,


Me.Width= ...

will resize the form (an horizontal scrollbar may
appear), but keeping its visual "size" on the screen

DoCmd.MoveSize ,,newWidth, newHeight

will resize the visual space, on screen, occupied by the
form having the "focus".


Hoping it may help,
Vanderghast, Access MVP

 

[Lodewijk]

thanks, it works!

 

[Peter De Baets]

Is i possible to resize the form after the user hits a button?

I have a form which shows the contents of a table. With the button cmdNew a
new record cabn be added. At that time some more fields are shown to fill
in, so I want to form to become lager.

--

Try increasing the value of the form InsideHeight property. Ex.:

me.insideheight = me.insideheight + 1440 '* Increase form height by an inch.

Hope this helps,

Peter De Baets
Peter's Software - MS Access Tools for Developers
http://www.peterssoftware.com