Scroll Bar in Continuous Form

[spudracer]

I've searched, and searched, and searched, but no dice.

I've got a continuous form that displays my massive 3,000+ inventory, with the option to filter down to specific categories. Some categories have 5 items, others have hundreds. The design I have used makes it look really tacky once I filter down to one of the categories that has 5 items, because there is no scroll bar.

What I've tried using is:

If Me.RecordsetClone.RecordCount < 10 Then
Me.Scrollbars = 2 'vertical only
Else
Me.Scrollbars = 2 
End If

But it still doesn't display correctly (nobar.png).

This is probably my biggest headache right now, and every "solution" I've found, doesn't work.

 

[vbaInet]

The image you've attached doesn't make any sense to me, it probably does to you as the developer.

 

[spudracer]

It's just the blank space left at the right side of the form when there are less than 10 records (where the scrollbar should be).

 

[vbaInet]

It still isn't making much sense to me. Show us a full form (blanking out any confidential info) and point to the relevant section(s) that you're querying.

 

[spudracer]

How's this?

 

[vbaInet]

There would only be a scroll bar if you need to scroll down to view the rest of the records. From the little you've shown, I've counted all 17 records.

 

[spudracer]

That's the problem. I want there to always be a scroll bar displayed.

 

[vbaInet]

How is that a problem?

 

[spudracer]

I want the scroll bar to always display.

 

[vbaInet]

This is how it's built and it's not a design flaw. Scroll bars should only show up when there's need to scroll down.

If you want your users to always scroll up and down then you need to make the footer section taller or put your form in a subform control.

 

[spudracer]

So design-wise, is there anything that can be done to that area where the scroll bar would normally be (if it's not visible)?

That little blank section is driving me crazy, I just want to be able to cover it up.

 

[vbaInet]

I don't see why that should drive you crazy and I'm sure it won't drive your users crazy. I would take it as poor design if I saw a scroll bar present when there's nothing to scroll to.

And no there's nothing you can do on the design front. If you want to take this any further then you want to look into API calls that will replace the Access scroll bar entirely and you would have to write code to manage the scrolling functionality.