The Spin Button control is used to increment or decrement a numeric value by clicking on or holding the mouse button down over the controlís "up" or "down" button.
It is commonly used with a text box containing a numeric value, and eliminates the need for users to manually enter values.
Easily add a Spin button to your Microsoft Access form. Place the spin button next to the textbox you want it to modify. Then set its properties and write a little code.
No programming is required for the spin button. It automatically increments or decrements its value based on the user's button click.
All of its properties can be set via VBA. You can also reference its Value property in code and use it accordingly. Its OnChange event fires when the user presses a button to change the value.
For more detailed information, you can use the control's MouseDown event to determine which button and whether the Ctrl key is depressed.
Supports Microsoft Access 2016, 2013, 2010, 2007, 2003, 2002, and 2000