Board index » VBA

All times are UTC



 Auto Resize Controls With Form 
Author Message
Vincent D
#1 / 11
 Auto Resize Controls With Form

    is there anyway that we can resize all the controls in a form once the
form is resize?  Thanks


Mon, 25 Feb 2002 03:00:00 GMT  
Dirk Goldga
#2 / 11
 Auto Resize Controls With Form
I'd guess that you could write a subroutine that would resize all the
controls, and call it from the form's Resize event.  This would not be a
simple routine to write, however.  You might get some ideas from past
threads on the subject of automatically resizing forms based on changes in
screen resolution.

--

Quote:

>    is there anyway that we can resize all the controls in a form once the
>form is resize?  Thanks



Mon, 25 Feb 2002 03:00:00 GMT  
M.L. Sco Scofiel
#3 / 11
 Auto Resize Controls With Form
I've seen ActiveX controls for VB to do this automatically, but I've never seen one for Access.  (Access draws controls on forms
differently that VB.)  There is a section in the "Access 97 Developer's Handbook" from Sybex by Ken Getz, et. at. that talks about
the issues and has some code.

--

Sco

M.L. "Sco" Scofield, MCT, MCP, MSS
Useful Metric Conversion #4 of 19: 2000 mockingbirds = two kilomockingbirds

Quote:

>     is there anyway that we can resize all the controls in a form once the
> form is resize?  Thanks



Tue, 26 Feb 2002 03:00:00 GMT  
Joe Fallo
#4 / 11
 Auto Resize Controls With Form
It has ALL the code.
It works fairly well.
There is a program called Shrinker Stretcher that does the same thing.
--
HTH
Joe
Check out Dev Ashish's web site for answers to common questions
http://www.mvps.org/access/



Quote:
> I've seen ActiveX controls for VB to do this automatically, but I've never

seen one for Access.  (Access draws controls on forms
Quote:
> differently that VB.)  There is a section in the "Access 97 Developer's

Handbook" from Sybex by Ken Getz, et. at. that talks about
Quote:
> the issues and has some code.

> --

> Sco

> M.L. "Sco" Scofield, MCT, MCP, MSS
> Useful Metric Conversion #4 of 19: 2000 mockingbirds = two
kilomockingbirds




Quote:
> >     is there anyway that we can resize all the controls in a form once
the
> > form is resize?  Thanks



Tue, 26 Feb 2002 03:00:00 GMT  
Dave McCloske
#5 / 11
 Auto Resize Controls With Form
Agree, the adh code works fairly well.  Requires some form
redesign/tweaking.

But I've been unable to apply it to anything except single page forms?
Anyone have any workarounds for this issue?

Dave McCloskey



Thu, 28 Feb 2002 03:00:00 GMT  
PDD
#6 / 11
 Auto Resize Controls With Form


Quote:
>     is there anyway that we can resize all the controls in a form
once the
> form is resize?  Thanks

ShrinkerStretcher is an Access module that will do this for you. You
can download a demo from:

http://www.peterssoftware.com

Thanks,

--
Peter De Baets

http://www.thepaintedid.com - The Painted iD
http://www.peterssoftware.com - Peter's Software - MS Access Tools

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.



Sat, 02 Mar 2002 03:00:00 GMT  
Dmitri Soroki
#7 / 11
 Auto Resize Controls With Form
Try SOD Control Resizer:
http://home.a-city.de/dmitri.sorokine/

Dmitri Sorokin



Quote:
> I've seen ActiveX controls for VB to do this automatically, but I've never

seen one for Access.  (Access draws controls on forms
Quote:
> differently that VB.)  There is a section in the "Access 97 Developer's

Handbook" from Sybex by Ken Getz, et. at. that talks about
Quote:
> the issues and has some code.

> --

> Sco

> M.L. "Sco" Scofield, MCT, MCP, MSS
> Useful Metric Conversion #4 of 19: 2000 mockingbirds = two
kilomockingbirds




Quote:
> >     is there anyway that we can resize all the controls in a form once
the
> > form is resize?  Thanks



Sun, 03 Mar 2002 03:00:00 GMT  
M.L. Sco Scofiel
#8 / 11
 Auto Resize Controls With Form
The add says it's for VB.  Have you tested it in Access?

--

Sco

M.L. "Sco" Scofield, MCT, MCP, MSS
Useful Metric Conversion #4 of 19: 2000 mockingbirds = two kilomockingbirds

Quote:

> Try SOD Control Resizer:
> http://home.a-city.de/dmitri.sorokine/

> Dmitri Sorokin



> > I've seen ActiveX controls for VB to do this automatically, but I've never
> seen one for Access.  (Access draws controls on forms
> > differently that VB.)  There is a section in the "Access 97 Developer's
> Handbook" from Sybex by Ken Getz, et. at. that talks about
> > the issues and has some code.

> > --

> > Sco

> > M.L. "Sco" Scofield, MCT, MCP, MSS
> > Useful Metric Conversion #4 of 19: 2000 mockingbirds = two
> kilomockingbirds



> > >     is there anyway that we can resize all the controls in a form once
> the
> > > form is resize?  Thanks



Thu, 07 Mar 2002 03:00:00 GMT  
Dmitri Soroki
#9 / 11
 Auto Resize Controls With Form


Quote:
> The add says it's for VB.  Have you tested it in Access?

There are two SOD Control Resizer: for VB and for Access.
The control for Access is called SOD Control Resizer lite.
You can download it here:
http://home.a-city.de/dmitri.sorokine/sodreslt.zip

Thanks
Dmitri Sorokin



Fri, 08 Mar 2002 03:00:00 GMT  
 
 Page 1 of 1
  [ 11 post ] 

 Relevant Pages 

1. Auto resize FORM and all controls depending on screen resolution

2. VB 4.0 Form/Controls Auto Resize to Fit the Screen Size

3. Auto resize forms???

4. MDI Child Form Auto-Resizing (??)

5. Please Help -- Auto-Resize of a Form

6. auto resizing Msflexgid to match form size

7. resizing a form when a control resizes during execution

8. Resize form - resize controls

9. Correction: Resize form - resize controls

10. Resizing a control when the Form is resized

11. resizing a form when a control resizes during execution

12. Resizing all controls at form resize

  

 
Powered by phpBB® Forum Software