By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,204 Members | 1,178 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,204 IT Pros & Developers. It's quick & easy.

Form fills the whole screen

P: 21
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
Feb 13 '08 #1
Share this Question
Share on Google+
4 Replies


Expert Mod 2.5K+
P: 2,545
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
Feb 13 '08 #2

P: 21
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
Feb 13 '08 #3

P: 94
Stick the following code into your Form's "On Open" and "On Load" procedures
Expand|Select|Wrap|Line Numbers
  1. DoCmd.Restore
Feb 13 '08 #4

P: 21
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
Feb 14 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.