A97 Hide Subform Scroll Bars

  • Thread starter Thread starter Kahuna
  • Start date Start date
K

Kahuna

I have a subform that is showing both scroll bars - though they are turned
off in the actual subform they appear when its shown on the main form.

Is there any way to turn them off completely?
 
is the subform in Datasheet view? if so, the ScrollBars property setting has
no effect; each scroll bar will show up when the datasheet is longer and/or
wider than the subform control in the main form.

hth
 
Kahuna said:
I have a subform that is showing both scroll bars - though they are turned
off in the actual subform they appear when its shown on the main form.

Is there any way to turn them off completely?
Click to expand...


You may be seeing the subform control's scroll bars, not
scroll bars of the form object displayed in the subform
control.

Test this by making the subform control large enough to
display the entire form object.
 
You may be seeing the subform control's scroll bars, not
scroll bars of the form object displayed in the subform
control.

Test this by making the subform control large enough to
display the entire form object.
Click to expand...

Yes that's what I'm seeing Marshall - Tina thinks these cant be turned off?

Kahuna
 
Kahuna said:
Yes that's what I'm seeing Marshall - Tina thinks these cant be turned off?
Click to expand...


I believe tina is correct. Why not just make the subform
control big enough to display the entire form so the scroll
bars are not needed?
 
That's not possible in all cases (sometimes the subform has 1 record and
sometime 15). Screen space is limited in this app.

Thanks for the feedback all.
 
What was referred to was the subform's control on the main form, not the
subform itself.

Kahuna said:
That's not possible in all cases (sometimes the subform has 1 record and
sometime 15). Screen space is limited in this app.

Thanks for the feedback all.

--
Kahuna
------------
Marshall Barton said:
Kahuna said:
You may be seeing the subform control's scroll bars, not
scroll bars of the form object displayed in the subform
control.

Test this by making the subform control large enough to
display the entire form object.

--
Marsh
MVP [MS Access]

Yes that's what I'm seeing Marshall - Tina thinks these cant be turned
off?
Click to expand...


I believe tina is correct. Why not just make the subform
control big enough to display the entire form so the scroll
bars are not needed?
Click to expand...
Click to expand...
 
What was referred to was the subform's control on the main form, not the
subform itself.
Click to expand...

There is no Scroll Bar property on the subform's control on he main form
Bob.

--
Kahuna
------------
Bob Howard said:
Kahuna said:
That's not possible in all cases (sometimes the subform has 1 record and
sometime 15). Screen space is limited in this app.

Thanks for the feedback all.

--
Kahuna
------------
Marshall Barton said:
Kahuna wrote:


You may be seeing the subform control's scroll bars, not
scroll bars of the form object displayed in the subform
control.

Test this by making the subform control large enough to
display the entire form object.

--
Marsh
MVP [MS Access]

Yes that's what I'm seeing Marshall - Tina thinks these cant be turned
off?


I believe tina is correct. Why not just make the subform
control big enough to display the entire form so the scroll
bars are not needed?
Click to expand...
Click to expand...
Click to expand...
 
Kahuna said:
That's not possible in all cases (sometimes the subform has 1 record and
sometime 15). Screen space is limited in this app.
Click to expand...


I just don't get it.

You want to display a form in datasheet view with no scroll
bars and you also want to suppress the automatic scroll bars
when the subform control is too small to display the form.
This implies that you only want to display some few records
with no facility to see the non visible records.

If that unusual objective is your goal, then you should do
something in the subform's record source query to reduce the
data to the fields/records that will fit in the available
space.
 
Marshall said:
I just don't get it.

You want to display a form in datasheet view with no scroll
bars and you also want to suppress the automatic scroll bars
when the subform control is too small to display the form.
This implies that you only want to display some few records
with no facility to see the non visible records.

If that unusual objective is your goal, then you should do
something in the subform's record source query to reduce the
data to the fields/records that will fit in the available
space.
Click to expand...

Marshall, while a bit unusual of a setup the user would still be able to view
all records with the navigation buttons even if there was no scroll bar.

Kahuna, it appears that suppressing the vertical scrollbar is not possible with
datasheet view (at least not in my testing). You could set the form up as
continuous view and then the scrollbar can be turned off. If desired you can
configure the continuous form so that it looks just like a datasheet view.
 
Kahuna, it appears that suppressing the vertical scrollbar is not possible
with datasheet view (at least not in my testing). You could set the form
up as continuous view and then the scrollbar can be turned off. If
desired you can configure the continuous form so that it looks just like a
datasheet view.
Click to expand...

Thanks for that Rick - I'll investigate that further.
 
If that unusual objective is your goal, then you should do
something in the subform's record source query to reduce the
data to the fields/records that will fit in the available
space.
Click to expand...

Thanks for feedback Marsh - but (as Rick mentioned below) you can still view
/ navigate the datasheet even without the scrollbars - and that is what I
was hoping to do (the scrollbars effectively hide the last record in the
data sheet for the great majority of the subrecords). Reducing the numbers
of records in the subform will defeat the object of the exercise.

Cheers
 
Rick said:
Marshall, while a bit unusual of a setup the user would still be able to view
all records with the navigation buttons even if there was no scroll bar.

Kahuna, it appears that suppressing the vertical scrollbar is not possible with
datasheet view (at least not in my testing). You could set the form up as
continuous view and then the scrollbar can be turned off. If desired you can
configure the continuous form so that it looks just like a datasheet view.
Click to expand...


All true, Rick, but I just don't understand the objective
and hesitate to offer an alternative approach to try to meet
an unknown requirement. I assumed that if no scroll bars
are allowed, then the nav buttons, which can include a
horizontal scroll bar, are also undesirable.

I hope your idea is accptable to Kahuna so I can set my
confusion aside.
 
All true, Rick, but I just don't understand the objective
and hesitate to offer an alternative approach to try to meet
an unknown requirement. I assumed that if no scroll bars
are allowed, then the nav buttons, which can include a
horizontal scroll bar, are also undesirable.

I hope your idea is accptable to Kahuna so I can set my
confusion aside.
Click to expand...

Marsh - worry not my dutiful aide!

I can circumnavigate the horizontal scrollbar, and have done so by setting
the column widths of the subform - just the vertical bar now taking-up
unnecessary space.

But if its not possible then so be it - I'll investigate Ricks solution for
this app.

Thanks for all the feedback.
 
Back
Top