We help IT Professionals succeed at work.

Why is only part of the form displayed in Access 2010?

Biopsych
Biopsych asked
on
37 Views
Last Modified: 2016-03-04
In an Access 2010 DB, we created a form that only displays a small part of the form in Form View.

I have attached screen shots of design view and form view.  I do not see an option in Properties that would
allow me to increase the size of the form. Please advise. Thanks
FormView.png
Designview.png
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2016

Commented:
while in Form view, in the Window section of the ribbon, click Size to Fit Form then save
CERTIFIED EXPERT
Most Valuable Expert 2014

Commented:
In your FormView, you have a scrollbar
With your design, only items 1-13 show initially, and then you must scroll.
You have a Form Header.
That will always show in its entirety
I suspect you have a Form Footer with a lot of empty space.
That, too, will show in it's entirety, and is probably the issue
Shrink it to nothing, if you can.

The detail section is what is made to scroll when all three parts of the form cannot fit on the screen

Author

Commented:
Ray Obrero
Already tried Click size to fit form and made no difference.
Should have said that in my post. Any other ideas?

Nick67
Shrunk the footer to nothing and made no difference. Any other ideas?
CERTIFIED EXPERT
Top Expert 2016

Commented:
can you upload a copy of your db.. or just create a blank db, import all related objects from the original db then upload
CERTIFIED EXPERT
Most Valuable Expert 2014
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
CERTIFIED EXPERT
Distinguished Expert 2017
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Thanks for your input.  It appears the problem may be that the person who created the form (not me)
attached the combo boxes (Items #14 - #38) below the ones that are visible. There are 38 items you can only see the first 13.
I attempted to unattach them all by clicking on the paperclick in design view.
This did not work is there another way to unattach the cbo boxes?
Thanks
CERTIFIED EXPERT
Top Expert 2016

Commented:
did you try select the combo and hit delete
CERTIFIED EXPERT
Most Valuable Expert 2014

Commented:
If you need the controls, you need them.
Play with the size of the form footer in this sample, and note how the height of the detail section varies as a result.

Post an image of the bottom of your form in design view
test.mdb

Author

Commented:
Unattached boxes by clicking on Arrange > Remove layout

PatHartman - Great suggestion to put items in two columns and shrink space between items.
This should solve part of the problem. Still think more of the form should be visible.

Nick67 - attached footer in Design view.

Ray Obrero - would like to see if we can solve without posting the DB.
Screen-Shot-2016-03-04-at-12.14.16-P.png

Author

Commented:
Nik67
Hide footer appears to have solved the the main issue.


Will also award points to
PatHartman - Great suggestion to put items in two columns and shrink space between items.
This should solve part of the problem. Still think more of the form should be visible.

Thanks for your invaluable input.
CERTIFIED EXPERT
Top Expert 2016

Commented:
<Unattached boxes by clicking on Arrange > Remove layout>
from the image you uploaded on your original post,
 the controls are not STACKED, that is why i ask if you could upload a copy.
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.