scrollbar controls

[123xxxxx]

i am trying to put the scrollbars to update a data field, type number,
what i want to do is everytime i click the upper arrow add 1 to the total
and everytime i click the lower button subtract 1
on what event do i put this under

i only got
On Update
On Enter
On Exit
On Got Focus
On Lost Focus

am i using the right method to do this, using the microsftForms 2.0, class
Forms.ScrollBar.1
or what shall i use to achieve this matter

 

[Cheryl Fischer]

As far as I know, Access does not make scrollbar events available, but, if
anyone may have done anything in this area, it would be Stephen Lebans. His
website is http://www.lebans.com

Alternatively, you may want to experiment with the use of the Microsoft
UpDown Control.

 

[Stephen Lebans]

The MS Forms 2.0 controls are not compatible with Access Forms. These
controls are also not freely redistributable.

It sounds like you merely want a SpinButton control. There are sample
Buttons here created entirely in Access:
http://www.lebans.com/formdimensions.htm

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[123xxxxx]

thank you two much appreciated