Hi all

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

Robert

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

Jim


Edited by: AQM_UK on Wed Feb 13 5:47:13 EST 2008.

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..

Martijn

Thanks

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???

Robert

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...

DoCmd.Restore

See if these work.

Hi,
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:

http://www.access-freak.com

They specifically deal with switching between the 2003 and 2007 user interface.
HTH
Good luck

Thanks very much.

The overlapping windows works!

Robert

You're welcome.
Good luck on future projects!