Solved

Forms: cannot change detail height!

Posted on 2008-10-16
12
930 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
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
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

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.  

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.
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
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…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

615 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