[AccessD] A2K - Forms not sizing correctly

Reuben Cummings accessd at gfconsultants.com
Fri Jan 7 13:48:48 CST 2011


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







More information about the AccessD mailing list