White space on form

terrytek

Registered User.
Local time
Today, 15:01
Joined
Aug 12, 2016
Messages
75
Pictures of my form in Form View and Design View are attached. All the tab controls are the same height as the one showing in the picture, and there are no other controls between the tab control and the footer. Some of the tab controls have subforms on them, but the subforms are all smaller than the tab control. In design view, the footer is just under the end of the tab control, but in form view, there is a big white space between the bottom of the tab control and the footer. How can I get rid of this white space so that "test" shows up just below the edge of the tab controls?
 

Attachments

  • FormView.PNG
    FormView.PNG
    21.8 KB · Views: 1,004
  • DesignView.PNG
    DesignView.PNG
    40.2 KB · Views: 858
The work box in the tab is wide to fit other tabs.
Grab the bottom right corner of the box and shrink it.
But if there are controls on other tabs using the space, it won't shrink.
 
The work box in the tab is wide to fit other tabs.
Grab the bottom right corner of the box and shrink it.
But if there are controls on other tabs using the space, it won't shrink.

There are no other controls there. If you look at the Design View picture, I have shrunk the work box as much as possible, but in Form View there is still that huge white area between the bottom of the tab box and the footer.
 
You don't say what version of Access you're using, but I'm willing to bet that it is post-2003! Many things work differently in post-2003 Databases because of the Document Window Options, a new option with 2007/2010, which defaults to 'Tabbed Documents.' Changing this option to Overlapping Windows basically causes many things in Form Design to act like they did pre-2007...in this case, I suspect, the empty space at the bottom will disappear, and reflect how the Form looks in Design View.

For v2007

  1. Go to Office Button (Big Icon, Top/Left)
  2. Click on Access Options (bottom, right of Dialog Box)
  3. Click on Current Database
  4. Under Document Window Options tick Overlapping Windows
  5. Click on OK (Bottom, Right)
  6. Close the Messagebox, then Close and Re-open Access

For v2010

  1. Click on FILE in the menu (top left)
  2. Click on OPTIONS (just above EXIT)
  3. Click on Current Database in left hand pane
  4. Under Applications Options, look for Document Window Options, tick Overlapping Windows
  5. Click on OK (Bottom, Right)
  6. Close the Message box, then Close and Re-open Access
Linq ;0)>
 
Last edited:
Missinglinq,

I am using Access 2007, and right you are! I already had "overlapping windows" checked, but I guess I had not closed and reopened the database since I had worked on that particular form. Now form looks great without a lot of wasted white space.
Thank you so much!
 
...I already had "overlapping windows" checked, but I guess I had not closed and reopened the database since I had worked on that particular form...

Yes, doing #6 above is important...and while I can't think of any other Option that requires that this be done, there must surely be one or more! But, of course, we're talking about the Boys of Redmond!

Having Tabbed Documents as the Default for this Property irritates many experienced Access developers! Besides the obvious, such as having huge 'blank areas' on Forms that are not part of the Form design, as you object to, many of the things we used to do in tweaking how Forms look...size...location...etc...simply don't work unless the property is set to "Overlapping Windows."

The absolutely first thing I do, when creating a new file, is to make this change then Exit and Re-open the file!

Glad we could help!

Good luck with your project!

Linq ;0)>
 

Users who are viewing this thread

Back
Top Bottom