Removing a subform's horizontal scrollbar

[Apothecary]

I have an Access 2000 database running under Win XP SP2 that uses a
subform on the main data entry form. The subform is in an area with
limited space so I'd like to eliminate the horizontal scrollbar so
more of the data shows. I have set the subforms "Scroll bar"
property to both "Vertical only" and "Neither" but I still
cannot remove the horizontal scrollbar. Is there some reason why this
does not work in a subform or is there some setting somewhere that
overrides the subform's "Scroll bar" property setting? Can I
better control the scrollbar by setting the property with VBA in the
formLoad event? This is a minor issue but it has gotten to be a
challenge now. Thank you very much for your help with this question.
Michael

 

[Allen Browne]

Michael, did you set Navigation Buttons to No as well?

If not the space beside the nav buttons (where the horizontal scrollbar
goes) will still be used up.

 

[Apothecary]

Allen,

Yes, it is set to No. I have toggled most every property just to see
if any of them changed the stituation but to not avail. It looks like
I will just need to learn to love scroll bars. Thanks for your help.

 

[George Nicholson]

Open the subform in design view. Make sure it is *not* maximized. Manually
resize the subform window borders (especially the right one) so that you can
see all but 1 to 2 "design window border widths" of the subform itself.
*Save*. Check how it looks in Form view by itself. Adjust in design view &
resave as necessary. (or: keep moving the right border inward until you can
see that you've gone to far and then move it back out a bit)

Then, see how the subform looks when in the subform control.

HTH,

 

[François Uldry]

Exactly what I was going to say, just make sure that the form you base your
subform on has a width which is smaller that the width of your subform
control.

That should remove the horizontal bar entirely as it won't be necessary
anymore. (It is shown only if it is required anyway).

Francois