• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 215
  • Last Modified:

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
0
alexisbr
Asked:
alexisbr
  • 8
  • 3
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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 MVP, Access and Data Platform)Commented:
And actually the Display Document Tabs needs to be checked to get this effect.
Capture2.jpg
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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 MVP, Access and Data Platform)Commented:
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 MVP, Access and Data Platform)Commented:
ok ... standby ...

mx
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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 MVP, Access and Data Platform)Commented:
you are welcome.  took me a bit ... like WTH ...

mx
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

  • 8
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now