Controls on a form - spinner button

[mavver]

Is it possible to have a spinner button on an access form, similar to what is in Excel?

I want the user to be able to select a percentage value and then have access limit the results brought back based on this selection, and would prefer it to be automated rather that have the user type in the value in a text box.

If it is possible can someone point me in the right direction to go looking for it?

If not, can someone suggest an alternative method?

As always, thanks in advance.

Mav

 

[ColinEssex]

You could use a ComboBox

Col

 

[mavver]

yeah, but it is very crude having a 100 line drop down list, but I think that this is the only way to go

Ta for the reply

 

[ColinEssex]

are the spinners available as an ActiveX control? (sorry I haven't checked)

Col

 

[CraigDolphin]

I did something similar in one db using two command buttons with the caption set to Ù (Wingdings font) or Ú. Then size the buttons as appropriate and arrange next to the textbox you want the value stored in.

Put code behind the buttons to increment the value in the adjacent text box up or down (depending on which button is pushed), and use Me.repaint to show the change in value. Then set the autorepeat property of the command buttons to Yes.

If the user clicks and holds the mouse button down, the action repeats. I also tested the value in the text box to ensure that upper and lower limits could not be exceeded (I was using this as a time picker, see attached jpg)

 

[CEH]

Maybe this will help you
http://www.samspublishing.com/articles/article.asp?p=727322&seqNum=3&rl=1