SpinButton Function

[dchendrickson]

In the form I am working on, a Microsoft Forms v2.0
SpinButton seems like it will do just what I need. But I
can't find any documentation or programming examples. Can
someone please direct me to a reference for using this
control. Thanks.

 

[Michel Walsh]

HI,

I am not familiar with the one coming from Microsoft Forms. Did you see
it in the Browser (F2) ? Automation doesn't work? You may get a "buddy"
control property, that is the name of the control getting the "result" of
the manipulation, short of that, I thing every thing else should be trivial,
more or less. Note that VB6 call it the UpDown control. Here, some code
(from VB6 help file)

================
Private Sub Form_Load()
' The UpDown control is named "updToggle."
' An OptionButton control is named "optToggle."
With updToggle
.BuddyControl = optToggle
.Min = -1
.Max = 0
.Increment = 1
.Wrap = True
End With
End Sub

' Change the Value of the OptionButton with
' the UpDown control's Value property.
Private Sub updToggle_Change()
optToggle.Value = updToggle.Value
End Sub

==================


Hoping it may help,
Vanderghast, Access MVP

 

[dchendrickson]

Michel,

Thanks for responding.... I actually answered my own
question.

I am using Access 2002/XP and grabbed the spinbutton
control from the More Controls drop down. It was listed
as a MSForms 2.0. I was able to finally track down the
associated help file by opening the Object Browser,
searching on spinbutton, and then clicking on the
help "?" in the browser once the MSFORMS spinbutton item
was found. I got the familiar MS Windows "creating help
database for first time use" message and bang!

The quirky part is that the help info still doesn't come
up when searching through VBA Help or Access Help. The
only way back to it is the path outlined above.

Thanks.

-dc