By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,495 Members | 1,345 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,495 IT Pros & Developers. It's quick & easy.

Custom Scrollbar

P: 21
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.
Aug 14 '18 #1
Share this Question
Share on Google+
8 Replies


PhilOfWalton
Expert 100+
P: 1,430
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
Aug 14 '18 #2

twinnyfo
Expert Mod 2.5K+
P: 3,055
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!

;-)
Aug 14 '18 #3

PhilOfWalton
Expert 100+
P: 1,430
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
Aug 14 '18 #4

P: 21
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?
Aug 14 '18 #5

twinnyfo
Expert Mod 2.5K+
P: 3,055
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.
Aug 14 '18 #6

PhilOfWalton
Expert 100+
P: 1,430
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
Aug 15 '18 #7

zmbd
Expert Mod 5K+
P: 5,287
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.
Aug 15 '18 #8

P: 21
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.
Aug 15 '18 #9

Post your reply

Sign in to post your reply or Sign up for a free account.