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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|