Custom Scrollbar

[Squiddley1957]

I find the default vertical scrollbar to be inadequate for my use (continuous form); it's small and positioned too far to the right of other control buttons. Is there a simple-to-set-up alternative? I thought about an active-x slider control but not sure that this is the right approach.

[PhilOfWalton]

AFAIK, you can't do anything with the default scrollbars (other than showing them or hiding them)

However, if on the design tab, you select More --> ActiveX Controls--> Microsoft Forms 2.0 ScrollBar, that should get you started. Regret I have never used one, but certainly you can alter it's size.

There is an example here:-
https://access-programmers.co.uk/for...d.php?t=243278

Phil

[twinnyfo]

Phil!

Shame on you! I figured if anyone would have already done this, it would be you.

I can't believe you don't have this pre-packaged!

;-)

[PhilOfWalton]

I'm wounded to the core. Hari-Kari is the only option now. Bye.....

Actually there is a reason - In the past I used a Treeview control found in MSCOMCTL.DLL as menu system similar to this

The trouble was with every version of Access and every version of Windows, I had to find a version of MSCOMCTL that worked, and in the end gave up and now use a VBA userform.

So that's my excuse, and I'm sticking to it.

:-)

Phil

[Squiddley1957]

Ok so no custom scrollbar. Could I use two buttons, one up, one down? Presumably there's code to incrementally move by x amount the continuous subform. Is that feasible?

[twinnyfo]

The two buttons would be very doable. However, it would be very much similar to a “Move Next” or “Move Previous”. When all is said and done, though, if I had the choice, I would probably just suffer through the scroll bars.

But, if you want to try out something, we’d be glad to help you work through it.

[PhilOfWalton]

I think I sounded too pessimistic in my previous post.

My problems were with the ActiveX Treeview in MSCOMCTL.Dll. The scrollbar you need is also an ActiveX but in Microsoft Forms 2. So as that is part of Access, it probably will work OK

In the link I gave you, the scrollbar works perfectly, so I would give it a try.

The other thought is can you apply some sort of Filter to the Subform to reduce the number of records you need to trawl through?

Phil

[zmbd]

Squiddley1957: There are some "work arounds;" however, they are not easy, simple, nor (IMHO) reliable replacements for the scroll bar using VBA.

The ActiveX Slider isn't a replacement for the scrollbar. It has no "hooks" nor events to allow one to easily sync its movements to the form window.

API calls, I've seen a few API type calls to user32.dll calls used in an attempt to set the vertical scroll position and to set; however, nothing that is complete enough to use without a lot of work.

[Squiddley1957]

Thanks to everyone. I already have two or three layers of filters but I will take another look. The most annoying thing about the scrillbar is its size - especially if you are a of a certain age.