Solved

Forms: cannot change detail height!

Posted on 2008-10-16
12
924 Views
Last Modified: 2013-11-28
This is killing me! I have a form, the height of whose detail section I am trying to reduce. It is currently at 5.7 inches, I want to reduce to 5.25. In the detail section, there are 5 distinct pages - each of which holds a subform. I have reduced the size of the subform on each page - so that there is about a quarter inch of white space at the bottom. But I seem unable to reduce the white space!!
Any ideas??
Thanks, gurus!!
0
Comment
Question by:terpsichore
  • 6
  • 3
  • 3
12 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 22734380
there is an object in your detail section preventing the change to happen
perhaps a box, a vertical line or a gremlin...
0
 
LVL 22

Expert Comment

by:Kelvin Sparks
ID: 22734378
Check for any small object at the bottom - often a thin line that the footer bar obscures.

Often easiest done by extending the detail down and selecting an area at the bottom and seeing if any objects are selected.

There'll be something there to stop it. Also, use the object selection combo in the toolbar and go through every object in turn and see which one pops up as selected there.


Kelvin
0
 

Author Comment

by:terpsichore
ID: 22734537
I have done as you suggested, but still no luck! I turned the grid off, and lowered the footer, but it still won't let me shrink the detail section. Any other things I can try? Perhaps a setting on the tab or detail that is preventing this?
0
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 22734554
attach your db. check Attach File below
0
 
LVL 22

Expert Comment

by:Kelvin Sparks
ID: 22734584
There will be something there.

With the footer lowered, point you mouse about the original bottom left of the form (5.7) and hold the left button down and drag the the new botton of detail and right hand side of form and release. What ends up being selected?
0
 

Author Comment

by:terpsichore
ID: 22734597
Here you go.
db1.mdb
0
 
LVL 22

Expert Comment

by:Kelvin Sparks
ID: 22734658
Appears to be a tab control on the form which uses the size of the largest page - check them all out.


Kelvin
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 22734714
it is correct the tab control with a height of 5.7549"
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 22734759
it is the height of the subform sfSubProjects in the SubProjects tab
0
 

Author Comment

by:terpsichore
ID: 22734926
How do I fix this? I tried to reduce it, but it still won't let me!?
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 22734942
you have to reduce the height of the subform sfSubProjects first
0
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 22734952
or the box that holds the subform sfSubProjects in the SubProjects tab
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question