Spinner Control

[bigmatt1233]

Is it possible to create a spinner control on a Access Form? What I want it
to do is to increase or decrease a value in a text box on the same form. Any
help on this would be grateful

Matt

 

[Maurice]

It sure is. Try this:

In form design choose the toolbox and choose activex controls (more...). See
if you can find the control named: "Microsoft Forms 2.0 SpinButton". This
will place a spinbutton on your form.

Now in the VBA window look in the combobox which states general for the
Spnbutton option. In the combobox on the right choose two options they are
"SpinUp" and "SpinDown"

You will get two subs with no code line between them. This is where you type
the following lines:

me.yourtextbox=me.yourtextbox + 1 (for the SpinUp)
me.yourtextbox=me.yourtextbox-1 (for the SpinDown)

where you need to replace yourtextbox with the actual name of your textbox.

Reading all this you might wonder if this is also possible by adding two
regular buttons on your form which will act the same way. Try it out it will
do the same...

hth

 

[bigmatt1233]

What part of the property page do I need to click onto to get the VB page
your talking about?

Matt

 

[Maurice]

You can get there by clicking ALT-F11