Solved

Forms: cannot change detail height!

Posted on 2008-10-16
12
923 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
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 
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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How Do I Select a Record using a Primary Key 3 30
Modal form 11 30
Question about DB Schema 27 56
Difference between tabbed sub form and navigation sub form 6 12
Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

809 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