FormResize code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Cristo said:
Hello,
I am sure somebody already asked the question but I am looking for the
Click to expand...
right code to resize a form and its objects to the screen resolution when
used on different computers.
 
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
 
Back
Top