Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Forms: cannot change detail height!

Posted on 2008-10-16
12
Medium Priority
?
931 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 
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 2000 total points
ID: 22734952
or the box that holds the subform sfSubProjects in the SubProjects tab
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

688 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