FormResize code

[Cristo]

Hello,
I am sure somebody already asked the question but I am looking for the right code to resize a form and its objects to the screen resolution when used on different computers.
I would appreciate any help.
Thanks.

 

[Cheryl Fischer]

The "Access xx.x Developer's Handbook" by Ken Getz et al has code to do this
(and much more) - well worth the price of the book. This is also available
as a download (Form Scaling and Resizing Tool) from:

http://www.developershandbook.com/downloads.htm

hth,

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Hello,
I am sure somebody already asked the question but I am looking for the

right code to resize a form and its objects to the screen resolution when
used on different computers.

 

[Rick]

try this in OnOpen or if you have code for
transitioning/opening the form, write it in the after
update for that function.

Lets say you have a drop box and depending on the users
response, a specific form opens.

Private Sub SelectForm_AfterUpdate()

DoCmd.OpenForm "form name"
DoCmd.Maximize

end sub

Hope this helps