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