Feb 13 2008, 05:40 AM
I have a form with a specified width eg 8cm and it looks OK in Design view, but when I go to Form view it fills the whole screen. What settings do I need to change so that it remains the specified size when in form view?
Thanks in advance
Feb 13 2008, 05:46 AM
in the on open of the form use the DoCmd.MoveSize command
play with the settings to get the form in exactly the right place and size you like.
The numbers will look like 150,150,7000,4000
Edited by: AQM_UK on Wed Feb 13 5:47:13 EST 2008.
Feb 13 2008, 05:53 AM
It's also possible that there's a command to maximize the form in the on open event...
Another solution could be to turn of the Auto-resize property of the form..
Feb 13 2008, 06:28 AM
I tried these but to no avail.
In my form properties I tried to change the Moveable property to Yes but it kept reverting back to No!
Why is it so???
Feb 13 2008, 09:02 AM
On the On_Open event of the form, write code to set the movable property to no as shown...
Me.Moveable = False
Or enter the restore value on the On_Open event as such...
See if these work.
Feb 13 2008, 09:22 AM
since you are using Access 2007 I'm assuming that you are using tab windows instead of overlapping once. This would make the forms seem like they are maximized unless they are a pop or modal form. To switch to overlapping windows as you might be used to from earlier Access versions go to the big round office button in the top left...go to the Access Options button in the bottom right of the pull down...in the Access options dialog go to the Current Database page and change the window options to overlapping.
BTW...you might find the tutorials on my website helpful:
They specifically deal with switching between the 2003 and 2007 user interface.
Feb 13 2008, 08:02 PM
Thanks very much.
The overlapping windows works!
Feb 13 2008, 09:10 PM
Good luck on future projects!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here