[AccessD] Change the Design Time Height/Width of a Form usingVBA

Thanks for answering William, not what I was after. Controlling a window is
the same as manipulating a closed object. 

(I already resolved what I was having difficulty with, with the one
exception that I would like screen manipulations to be done with no
updating, so the user doesn't have to see my actions). 

Peter's software is interesting, but I don't think he's doing what I asked
about. Also, the words "container" or "document" do not appear in his code.

Bill



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Hindman
Sent: Thursday, May 20, 2010 4:11 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Change the Design Time Height/Width of a Form
usingVBA

http://www.peterssoftware.com/winmanip.htm

William

--------------------------------------------------
From: "Bill Benson (vbacreations)" <vbacreations at gmail.com>
Sent: Wednesday, May 19, 2010 6:28 PM
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Subject: [AccessD] Change the Design Time Height/Width of a Form using VBA

> Hi,
>
>
> When I used to code in VB6, I believe I recall being able to set a form to
> any dimensions I wanted, and could drag controls out of the working area
> (pluses and minuses of this) - apparently I cannot do this with Access 
> 2003
> forms?
>
> Why I want to: I build datasheet forms, drag fields onto the form... then
> find I have to grab each one and reposition it manually. For a datasheet
> form I don't really care what order the controls are in, but I would like 
> to
> see them all grouped in one place.
>
> I built a subroutine which repositioned my controls on a form which I open
> hidden. I would now like to change the form's height and width to just
> accommodate those controls and no more. But the only property I seem able 
> to
> manipulate is InsideHeight, which does not seem to work if the form is not
> in a window. Any other properties I can manipulate to accomplish this --  
> or
> anything I can do with container/document objects?
>
> Thanks
>
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
No virus found in this incoming message.
Checked by AVG - www.avg.com 
Version: 9.0.819 / Virus Database: 271.1.1/2883 - Release Date: 05/20/10
02:26:00