Vertical scroll bar only if subform grow too big?

[01jeffro]

ihave a subform on a form. most of the time i do not need scroll bars, but sometimes it is large enough to need vertical. i want the vertical scroll bar to show up only when needed, so it looks cleaner when the subform is short. any ideas?

 

[DougP]

That's the default anyway

What you need to do is make the form wide enough in design view so that if scroll bars are neede they have room to grow and not have the horizontal bars show up too.

So you wil have to put up with a 1/4" space on th erigh twhen the records are not enough to fil it up.
then when they are the scroll bars will just appear.

Ok Is that what you wanted to know??
DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[01jeffro]

DougP, thanks for your reply, but I am still having trouble. The horizontal only show up when needed, but the vertical bars are always there. even if there is only one record in a continous form that has room for 12 records before needing scrollbars. Thanks agian