A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Control Form Size in 2007



 
 
Thread Tools Display Modes
  #1  
Old November 27th, 2009, 07:04 PM posted to microsoft.public.access.forms
Ross
external usenet poster
 
Posts: 297
Default Control Form Size in 2007

I can't seem to figure out, in Access 2007, how to keep the form size from
changing once that I have set it.

For example, if I size my largest form in the project with the navigation
pane closed, and then open the form with the navigation pane open, the form
gets squeezed down (to automatically allow for the navigation pane.

I have turned off everything, autocenter, autoresize, etc and tried modal
and pop up version of the form but nothing seems to lock the size that I have
set.

Why is this? How do I fix this?

Thank you much

Ross
  #2  
Old November 28th, 2009, 03:22 PM posted to microsoft.public.access.forms
Mark Andrews[_2_]
external usenet poster
 
Posts: 600
Default Control Form Size in 2007

You can put a little code in the Form_open event

example:
DoCmd.MoveSize 0.7 *1440, 0.7 * 1440, 8 * 1440, 6 * 1440

In Access Options:
Office button, access options, current database
you can choose overlapping windows or tabbed documents
This will affect how windows open.

Hope these tips help,
Mark

"Ross" wrote in message
news
I can't seem to figure out, in Access 2007, how to keep the form size from
changing once that I have set it.

For example, if I size my largest form in the project with the navigation
pane closed, and then open the form with the navigation pane open, the
form
gets squeezed down (to automatically allow for the navigation pane.

I have turned off everything, autocenter, autoresize, etc and tried modal
and pop up version of the form but nothing seems to lock the size that I
have
set.

Why is this? How do I fix this?

Thank you much

Ross



  #3  
Old November 30th, 2009, 12:01 PM posted to microsoft.public.access.forms
Ross
external usenet poster
 
Posts: 297
Default Control Form Size in 2007

Hey Mark,

DoCmd.MoveSize 0.7 *1440, 0.7 * 1440, 8 * 1440, 6 * 1440

This is exactly what I needed. Exactly.

Thank you!!!

"Mark Andrews" wrote:

You can put a little code in the Form_open event

example:
DoCmd.MoveSize 0.7 *1440, 0.7 * 1440, 8 * 1440, 6 * 1440

In Access Options:
Office button, access options, current database
you can choose overlapping windows or tabbed documents
This will affect how windows open.

Hope these tips help,
Mark

"Ross" wrote in message
news
I can't seem to figure out, in Access 2007, how to keep the form size from
changing once that I have set it.

For example, if I size my largest form in the project with the navigation
pane closed, and then open the form with the navigation pane open, the
form
gets squeezed down (to automatically allow for the navigation pane.

I have turned off everything, autocenter, autoresize, etc and tried modal
and pop up version of the form but nothing seems to lock the size that I
have
set.

Why is this? How do I fix this?

Thank you much

Ross



.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:41 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.