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
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
Rey Obrero (Capricorn1)
while in Form view, in the Window section of the ribbon, click Size to Fit Form then save
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
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
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?
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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
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
did you try select the combo and hit delete
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
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
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
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
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.
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.
<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.
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.