Many Windows users would prefer to press buttons to increase or decrease a value rather than key in a value. The most typical example of spin buttons is the number of copies to print on the Print Dialog form. Beside the copies text box are two small buttons with up and down arrows on them. If you press the up button the number of copies is incremented and if you press the down button then the number of copies is decremented.
Access provides two alternatives for creating spin buttons.
However, OLE controls require that you distribute the control along with the Access MDB file. In addition, OLE controls require a great deal of memory to function responsively. If your target or destination computer has less than 16 megs of memory then OLE controls should be avoided unless sluggish response times are acceptable. Another spin button alternative involves using two command buttons and some code. While this is a less elegant approach than an OLE control, it is easier to distribute since you do not have to include the OLE control.