Form fills the whole screen

[RobertJohn]

Hi all

I am using Access 200. 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

[Stewart Ross]

From what you say you appear to have maximised the Design view window, so when you switch to Form view the form is maxmised too. If this is so it does not affect the form itself, which will still be the width you set it. Close the form, and if your database window is also maximised return this to normal. If you open your form now it should be the specified width.

I can't think of any other simple explanation - it is unlikely that you have put a window maximise event into your form...

Stewart

[RobertJohn]

From what you say you appear to have maximised the Design view window, so when you switch to Form view the form is maxmised too. If this is so it does not affect the form itself, which will still be the width you set it. Close the form, and if your database window is also maximised return this to normal. If you open your form now it should be the specified width.

I can't think of any other simple explanation - it is unlikely that you have put a window maximise event into your form...

Stewart

Thanks Stewart

However this doesn't make any difference.

In my form properties I tried to change the Moveable property to Yes but it kept reverting back to No!

Why is it so?? And is that likely to be a factor in my form size problem?

Robert

[Lewe22]

Stick the following code into your Form's "On Open" and "On Load" procedures

DoCmd.Restore

[RobertJohn]

Thanks to you all for your help. The problem was finally solved by switching to Overlapping Windows instead of the default Tab Windows in Access 2007. Also, Stewart, I had maximised the Design view window, and when I changed that it all fell into place nicely.

Thanks again.

The Forum is really helpful, especially for a beginner like me.

Robert