Scrollbar

[Aleksandra]

Hi!

How to use the Scrollbar from MS Forms2.0 with Access TextBox?

Thanks a lot...

 

[stopher]

Hi

The scrollbar control gives a slider representation of the data it is representing. Not to be confused with a scrollbar for scrolling the screen. I prefer the word slider for this reason.

You use it pretty much like any other control. Just add it to the control to your form. Then if you decide to bind the control to an underlying data source then set the Control Source in the properties. When you slide the slider to a new position, this will change the value in your table.

The control has a some important properties two of which are Min and Max. These can be set to the range you want for the slider e.g. if you set Min=0 and Max=100 then if you move your slider to one end it will represent 0 and the other 100. Also take a look at SmallChange (the step sixe when you click on the end arrows) and LargeChange (the step size when you click in the slider gap).

One final point, if your range is set to 0-100 and you have a record with a value of say 300, then you will get a message saying the control can't display the information.

hth
Chris

 

[stopher]

Sorry, I didn't read your question properly. Are you asking how to get a visual feedback of the slider value in a text box?

First add a textbox for the same datasource. Then add an On Updated event and just add the following line:
Me.Recalc

Now when you move your slider, the textbox will show the value at the same time.

hth
Chris

 

[Aleksandra]

Sorry, I didn't read your question properly. Are you asking how to get a visual feedback of the slider value in a text box?

First add a textbox for the same datasource. Then add an On Updated event and just add the following line:
Me.Recalc

Now when you move your slider, the textbox will show the value at the same time.

hth
Chris

Hi, Chris!

Thank you very much for the answer.

The problem is following.
There is a field (TextBox) in which the text is displayed.
I would like to remove a standard Scrollbar and to use the Scrollbar from MS Forms 2.0 or any another.
It is impossible to paint a standard Scrollbar, but I would like to have a Scrollbar of certain colour.
Have you any ideas?

Thank you again
Aleksandra

 

[missinglinq]

You're not paying attention to Chris' posts! As he's already told you, the Scrollbar from MS Forms 2.0 is not a replacement for the standard Access scrollbars used to scroll text, which is what you're talking about! It's a control that is used to change the value of a field, much in the same way as a slider control changes the volume in Windows Volume Control, This scrollbar is not used to scroll text!

As to changing the color of the standard scrollbars, that's determined by the individual PC's Windows setting, just like the color of command buttons. Some things. like command buttons, you can work around, placing colored labels on top of the buttons, but the design/nature of a scrollbar would preclude this type of hack.

 

[Aleksandra]

You're not paying attention to Chris' posts! As he's already told you, the Scrollbar from MS Forms 2.0 is not a replacement for the standard Access scrollbars used to scroll text, which is what you're talking about! It's a control that is used to change the value of a field, much in the same way as a slider control changes the volume in Windows Volume Control, This scrollbar is not used to scroll text!

As to changing the color of the standard scrollbars, that's determined by the individual PC's Windows setting, just like the color of command buttons. Some things. like command buttons, you can work around, placing colored labels on top of the buttons, but the design/nature of a scrollbar would preclude this type of hack.

Thank you...
But I also have written: "Scrollbar from MS Forms 2.0 or any another" .
Do you know any other Scrollbars? From other firms? (free is better).
It is possible to change colour with API, but API change colour for all 3D instead of a separate Scrollbar.

 

[missinglinq]

Don't know of any 3rd party fixes for this. This kind of thing is simply not a high priority with database developers as it might be in people who develop, say, websites or video games.

 

[Aleksandra]

Up - Up -