Solved

Forms: cannot change detail height!

Posted on 2008-10-16
12
926 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
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

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…
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

756 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