473,385 Members | 1,311 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Form fills the whole screen

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
4 5041
Stewart Ross
2,545 Expert Mod 2GB
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
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
Lewe22
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
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

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

Similar topics

2
by: Robin | last post by:
Ok, I have a form that on clicking of the Update button first updates the specific record in the db, then Inserts if the vMemo field is not empty. The problem that I'm having is that After...
10
by: Gregory A Greenman | last post by:
I'm trying to write a program in vb.net to automate filling out a series of forms on a website. There are three forms I need to fill out in sequence. The first one is urlencoded. My program is...
16
by: David Lauberts | last post by:
Hi Wonder if someone has some words of wisdom. I have a access 2002 form that contains 2 graph objects that overlay each other and would like to export them as a JPEG to use in a presentation....
1
by: Catherine Jo Morgan | last post by:
If I make a form in Access 2002 without thinking about making it resizable in different browser windows, can I add this feature later? Or do I need to do something about it right at the start, as...
3
by: Mike | last post by:
Hello: I was not able to find a regular ASP group, so I posted this here instead. I have a web app which is actually just ASP using VBScript as the server-side language, running on IIS6. ...
3
by: SDL | last post by:
stLinkCriteria = "CUSTOMER_ID = " & CUSTOMER_ID stDocName = "NEW INVOICE" DoCmd.OpenForm stDocName, , , stLinkCriteria "NEW INVOICE" opens with TONUMBER) in key field and no other data If I...
1
by: SeanR | last post by:
Hi, I wasn't happy with the customisability of the standard Windows form, so I decided to implement my own. Basically what I did was extend a borderless form and add my own borders and caption...
1
by: Denise | last post by:
I have several big forms that are Maximized on Load. I have "Jump" buttons on each to flip to other related forms. - 'Needs' form has jump button to it's linked Project, if it is linked - Project...
4
by: AAaron123 | last post by:
<body runat="server" id="MainBody"> <form id="form1" runat="server" style="background-color:green; width: 100%; height: 100%"> <br /> Table1" runat="server" Style="background-color:Yellow;...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.