Spin Button Alternatives?

[illini]

In Excel, VBA provides Spin_Buttons off the Toolbox. These allow you to increment a value up or down by a number. For instance, you could increase the time value within a textbox from 12:00 to 12:01 by clicking the Spin_Up on the Spin_Button.

Is there any similar option available within Access?

-illini

 

[DougP]

No
you could make you own

put two buttons on the form and have the caption = &quot;<&quot; for button on the left and &quot;>&quot; for the right.

then
when you click on the left button it would take the value you want to de-increment like so MyValue = MyValue -1

Right button
MyValue = MyValue +1

Thne you need an error trap

If MyValue < 1 then MyValue =1

If MyValue > MaxValue then MyValue =MaxValue DougP, MCP