Access 2007 Form not displaying scrollbars

Hi.  I cannot figure out why the scrollbars are not displayed on a single form.  I created this database 2 years ago and I can't remember why the forms all have tabs at the top, as I normally don't see tabs on my forms.  I wonder if that could be the problem.  I have scrollbars set to "both" on the form.  But I can't scroll down even though the form is too long to be displayed in its entirety on the screen.

Any help would be appreciated.  I've attached an image showing how the tabs look on the form.  I don't work with Access 2007 very often.  Is this how all forms appear in Access 2007?

Thanks,
Alexis tabs
alexisbrAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Not sure about A2007, but in A2010 there is the option you see in the image below ... which results in tabbed forms, etc., which I personally cannot stand.

mx
Capture1.jpg
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
And actually the Display Document Tabs needs to be checked to get this effect.
Capture2.jpg
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Now, I purposely made one form to be to long to fit, and there is a scroll bar on the very far right ...

mx
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

alexisbrAuthor Commented:
Thanks, MX.  I removed the checkbox as you said and the tabs are gone.  But I still don't have a scrollbar.

Here's a screenshot of my form.  I expected to have a scrollbar where I put the red arrow. I took the screenshot before I removed the tabs but that didn't affect the form showing any scrollbars.

Thanks,
Alexis

  no scrollbar
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Humm ... can you upload the db?
0
alexisbrAuthor Commented:
Ok.  I put just that form and fake data in a separate database.  I also removed some identifying controls and info from the form but it still shows the problem.  I have never had this problem before in any of the many databases I have created over the years so it must be something staring me right in the face that I can't see!

Thanks for your help.
Alexis FormMissingScroller.zip
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
ok ... standby ...

mx
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
The reason is because you have all the controls in the Form Header.  They need to be (or some at least) in the Detail section.

mx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
see attached db ...

mx
FormMissingScroller-MX01.zip
0
alexisbrAuthor Commented:
Oh my!  Thank you so much.  I didn't realize I put all the controls in the header section.  I never do that.   This has been driving me crazy so thank you again!
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
you are welcome.  took me a bit ... like WTH ...

mx
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.