Scroll bars in a subform?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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.
 
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.
 
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?
Click to expand...

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]
 
Sorry - didn't help

John Vinson said:
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]
Click to expand...
 
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
 
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.
 
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.
 
Access 2007 beta, TR2. And I'm not using any code on the subform - yet. Just
trying to get the form layout working first.
 
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.
 
Anyone? Bill, got any ideas?

Van T. Dinh said:
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.
Click to expand...
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subform Data Entry Setting 0
Unremovable horizontal scroll bar on subform 1
Mouse wheel 1
Scroll bar space 1
mirror data from subform to main form 3
Scroll a subform 6
Scroll bars 4
Parameter Value error in a Subform 0

Back
Top