Scroll bars in a subform?

[Guest]

I'm trying to create a form which has a subform embedded in it. The main
form is defined as a single form, and the subform is defined as a continuous
form. I want to include a scroll bar in the subform, and have "vertical
scroll bars" turned on in the subform's property sheet

All of the data fields show up in the subform, just as expected, and the
data is in continuous format. I can page up and down and see pages of data -
but the scroll bar doesn't show up at all.

Any ideas how to get them working?

 

[BruceM]

Are you saying you don't see Scroll Bar properties in the subform's property
sheet? If so, be sure you are looking at the properties for the subform
itself, and not the subform control. If the property sheet reads
Subform/Subreport at the top it is the subform control. If it reads Form it
is the subform itself. If it reads Subform/Subreport, try clicking inside
it while the property sheet is open, and see if the property sheet changes.
If you designed the subform as a separate form, you can edit it directly
from the database window; otherwise I think you will need to make changes
through the main form.

 

[Guest]

Actually, I mean that the scroll bars themselves don't show up. In the main
form, I have scroll bars turned off; in the subform I have them turned on
(vertical only). This should give me scroll bars in the subform.

If I view the subform alone, it does give me the vertical bar, but when it's
embedded in the main form, the vertical scroll bar doesn't appear.

 

[John Vinson]

I'm trying to create a form which has a subform embedded in it. The main
form is defined as a single form, and the subform is defined as a continuous
form. I want to include a scroll bar in the subform, and have "vertical
scroll bars" turned on in the subform's property sheet

All of the data fields show up in the subform, just as expected, and the
data is in continuous format. I can page up and down and see pages of data -
but the scroll bar doesn't show up at all.

Any ideas how to get them working?

Sounds like the Form within the subform control might be just a
quarter inch wider than the subform control itself.

Open the mainform in design view; select the edge of the subform;
doubleclick the lower right corner to resize the Subform control to
fit the form within it.

John W. Vinson[MVP]

 

[Guest]

Sorry - didn't help

Sounds like the Form within the subform control might be just a
quarter inch wider than the subform control itself.

Open the mainform in design view; select the edge of the subform;
doubleclick the lower right corner to resize the Subform control to
fit the form within it.

John W. Vinson[MVP]

 

[Guest]

Paul,

Be aware that sometimes, Access does not show the scroll bar unless it has
to. For example, if the subform fits 10 rows but you have only 9 rows showing
up, the scroll bar doesn't appear, the minute you add the 11th record, Access
shows the scroll bar.

Ray

 

[Bill Mosca, MS Access MVP]

Along with Ray's answer, you might check to see if the sub form is not
completely showing in the main. Turn on both scroll bars to test this. If
there is a horizontal bar showing, your main form is too narrow or you need
to widen the sub form control.

 

[Guest]

I turned on both vertical and horizontal scroll bars and widened the subform
control until I got both scroll bars (horiz and vert). Then I turned off the
vertical scroll (set it to horizontal only). I expected to see the horizontal
bar - since I didn't change the width - but not the vertical one. What
happened was that I lost both bars.

In other words, it seems able to display both bars or neither, but not one
or the other alone.

 

[Van T. Dinh]

Access 2000?

It may have something to do with this Microsoft Knowledge Base article:

http://support.microsoft.com/kb/311888

Check and make sure that you don't have code somewhere that change the
ScrollBars Property of the Form being used as the Subform. For sample code,
see the Microsoft Knowledge Base article:

http://support.microsoft.com/kb/207642

 

[Guest]

Access 2007 beta, TR2. And I'm not using any code on the subform - yet. Just
trying to get the form layout working first.

 

[Van T. Dinh]

Sorry, I am not that familiar with Access 2007 yet ...

Hopefully, other users with more Access 2007 testing experience can point
you in the right direction.

 

[Guest]

Anyone? Bill, got any ideas?

Sorry, I am not that familiar with Access 2007 yet ...

Hopefully, other users with more Access 2007 testing experience can point
you in the right direction.

 

[Bill Mosca, MS Access MVP]

Sorry, Paul. I'm in the same boat as Van. Maybe it's just a bug in 2007. I
wouldn't worry about it until it's released.