Forms not showing vertical scroll bars

[Paul Doree]

Hi all,

I can't see what's causing this. I have a subform which is fine when I open
it up on its own (datasheet view) - both scroll bars are showing. When I
put it on a main form and open up the main form with the sub form embedded,
the vertical scroll bar won't display in the subform.

Anyone come across this and know the reason?

Cheers

Paul

 

[Stockwell43]

Hi Paul,

I am assuming you have the subform set up as a datasheet view correct? If
so, depending on how far you have the form stretched (opened) in the main
form you won't see the vertical scroll bar until you place enough records in
it to reach past the bottom. I usually set mine to see 3 records and when the
forth one is entered then my vertical bar appears.

Hopes this helps!!!

 

[Paul Doree]

Hi,

I'm afraid both of these occurrences are where there are many records in the
subform, going well off the bottom.

Anyone got any ideas?

 

[Stockwell43]

Open the subform in design view and check the properties of the form an make
sure in the Scroll Bar section it says Both. When you do this, make sure you
are clicking on the little square box in the top left corner of the subform
so that a black square appears in the middle. If you click on the form and
you highlight the whole outter edge, you would get the correct properties
menu.

 

[Ron2006]

Here is another thing to look at, IF I can describe it properly. I
will give you an example that hopefully is clear enough that you can
extrapolate from there.


1) you take a subform and just opening the subform all by itself you
design all the fields, etc so that it will display as you want iin a
window that is 4 inches wide.

2) Now take a main form and drop that subform on it. But when you
resize the subform window make the window ONLY 3 inches wide.

I believe that when you now open the mainform is regular view you will
see a similar problem to the one that you are describing. I know you
get that in single and continuous form mode. And I believe you can
sometimes get it in datasheet mode also.

I have had similar problems even with datasheet view and in all cases
it has been a question of the layouts of the form and the size of the
window that the subform is trying to be shown in.

Ron