[AccessD] A2K - Forms not sizing correctly

In situations like this I usually use Docmd.Restore in the form's Open
event. And since I've also experienced Access 2007 resizing the form at
will, I've added this kind of code in the form's Load event:

Private Sub Form_Load()
   Me.InsideHeight = 9300
   Me.InsideWidth = 9960
End Sub

On Fri, Jan 7, 2011 at 11:48 AM, Reuben Cummings
<accessd at gfconsultants.com>wrote:

> I do save, Doug.  I've also been burnt by this in the past.
> What I have working right now, and I really like because form size
> basically
> will not be a problem even if I forget to save size changes, is adding two
> labels to each form and placing my desired size in those labels.
> When the form opens I'll pass the caption of those two labels to a function
> whose job it is to convert them to twips and run the docmd.movesize
> No matter how I save the form it will open to the size specified in the
> labels.
>
> My other thought was a table storing all the forms names with two more
> columns storing height and width.  Have the function call the size based on
> the form name and then run the movesize.
>
> I think I'll go with the labels though.  That way as I work on a form I can
> edit the size and all control all at one time rather than being forced to
> maintain a table as well.
>
>
> Reuben Cummings
> GFC, LLC
> 812.523.1017
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Steele
> Sent: Friday, January 07, 2011 12:12 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] A2K - Forms not sizing correctly
>
> I don't want to be insulting here, but after you've resized the form
> in design view are you saving it or just closing it?  I've been caught
> on that before.  It's my impression that sometimes I've had to save a
> form twice to lock in the size.
>
> Doug
>
> You could try using
>
> On Fri, Jan 7, 2011 at 7:22 AM, Reuben Cummings
> <accessd at gfconsultants.com> wrote:
> > I mean cropped I guess.  All the control are normal size and are all
> > available if I drag the right side border to the right.
> > If the form is supposed to be 4" tall by 6" wide (for example) it is
> opening
> > 4" tall by 3" wide.  The user can drag to the border and for the rest of
> > that session that form will remain at the newly created size.  However,
> the
> > next time it opens the forms are all back to 4*3
>
> --
> 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
>