hotathens
asked on
Slider Control MSaccess on update
The on update does not seem to work on the activex slider control, any clues ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
https://www.experts-exchange.com/questions/21145896/Getting-a-slide-control-to-update-a-text-box-as-it-is-moved.html?sfQueryTermInfo=1+control+slider&anchorAnswerId=12157311#a12157311
peter57r, (thenelson)
<The Change event doesn't show on the properties dialog but you can select it in the code module.>
Any idea why this happens?
I notice that the same thing happens for certain events with the calendar control as well.
(they are available in the VBE, but not in the property box)
Jeff
<The Change event doesn't show on the properties dialog but you can select it in the code module.>
Any idea why this happens?
I notice that the same thing happens for certain events with the calendar control as well.
(they are available in the VBE, but not in the property box)
Jeff
The events displayed on the property sheet are those of the container control.
The actual activeX control object sits inside this wherein its properties, methods and events are accessible.
Hence why the proper syntax for assignment of such control use is
Set objCtl = Me.ControName.Object
As for the event, well Change is alright, but I'd say the point of a control such as the slider is to make use of its dynamic movement (if you're going to include the potential burden of ActiveX controls, you might as well let them sing ;-)
Consequently, I'd say the Scroll event is more applicable than Change (which won't be raised as continuously, i.e. smoothly).
For example of the effect I mean - have a look at:
http://www.databasedevelop ment.co.uk /examples/ colourslid e.zip
Cheers.
The actual activeX control object sits inside this wherein its properties, methods and events are accessible.
Hence why the proper syntax for assignment of such control use is
Set objCtl = Me.ControName.Object
As for the event, well Change is alright, but I'd say the point of a control such as the slider is to make use of its dynamic movement (if you're going to include the potential burden of ActiveX controls, you might as well let them sing ;-)
Consequently, I'd say the Scroll event is more applicable than Change (which won't be raised as continuously, i.e. smoothly).
For example of the effect I mean - have a look at:
http://www.databasedevelop
Cheers.
Thanks
I don't think the default behaviour of the slider justifies the use of the term 'scroll'!
(Yes I know you can change it)(:-)
(Yes I know you can change it)(:-)