Avatar of Biopsych
Biopsych asked on

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

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
Microsoft Access

Avatar of undefined
Last Comment
Rey Obrero (Capricorn1)

8/22/2022 - Mon
Rey Obrero (Capricorn1)

while in Form view, in the Window section of the ribbon, click Size to Fit Form then save
Nick67

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
ASKER
Biopsych

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?
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
Rey Obrero (Capricorn1)

can you upload a copy of your db.. or just create a blank db, import all related objects from the original db then upload
ASKER CERTIFIED SOLUTION
Nick67

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
Biopsych

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
Rey Obrero (Capricorn1)

did you try select the combo and hit delete
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Nick67

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
ASKER
Biopsych

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
ASKER
Biopsych

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.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Rey Obrero (Capricorn1)

<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.