Resising form

L

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.
 
M

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
 
P

Peter De Baets

Lodewijk said:
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.

--
Click to expand...

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
 
Top