Scroll Bar

Parra

Well-known Member
Joined
Feb 21, 2002
Messages
752
I have a form that is too long to view on the screen so there is a horizontal scroll bar that appears...but then also the regular horizontal scroll bar appears. What can I do to eliminate the form's scroll bar, but still be able to view the form by using the windows regular scroll bar.

Am I making sense??? Give me a break, back to the office after a 4 day mini vacation. o_O

Thanks
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
In the form design view, go to the square in the top left hand corner of the form (between the rulers, if you have them on). If you right click on this, you can bring up the form properties box. Under the Format menu, simply select to turn all scroll bars off, or keep just one of the bars by using the "Scroll Bars" combo box. This will allow you to turn off the form scroll bars, but to keep the Access/Windows scroll bars that are automatic.

I hope this is what you wanted and that i have been of some help.

Chris



Rams for the Superbowl
 
Upvote 0
Yes it did, but the form's height can only be extended to about 7 inches. What if I need to extend it more?

Thanks
 
Upvote 0

Forum statistics

Threads
1,221,604
Messages
6,160,748
Members
451,670
Latest member
Peaches000

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top