By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,641 Members | 2,110 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,641 IT Pros & Developers. It's quick & easy.

Spin Buttons

P: n/a
I have autorepeat turned on for a command button that increments the value in a
textbox. When I click on the button and hold the mouse button down, the value in
the textbox does not change. When I release the mouse button, the value in the
textbox changes to where it incremented depending on the length of time I held
the mouse button down. How do I make the value "spin" in the textbox while I
hold the mouse button down?

Thanks!

Mark
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Tue, 06 Jan 2004 05:06:00 GMT, "Mark" <mm*****@earthlink.net> wrote:
I have autorepeat turned on for a command button that increments the value in a
textbox. When I click on the button and hold the mouse button down, the value in
the textbox does not change. When I release the mouse button, the value in the
textbox changes to where it incremented depending on the length of time I held
the mouse button down. How do I make the value "spin" in the textbox while I
hold the mouse button down?

Thanks!

Mark


Form performance reasons, Access does not update the display while a VBA
function is executing. You can force it to update the display by calling the
..Repaint method of the form.

Also, using a button for a spin control is annoying for 2 reasons. First, the
button takes the focus away from the control being "spun", which is hard to
get arouns. Second, the button border is too fat for such a small button. A
better thing to use is an Image or Label control. Either of these control
types can receive mouse events without tking the focus away from the control
being spun. Unfortunately, I don't think you can use auto-repeat with these
controls, so you have to use a timer even to spin while the mouse button is
down on the spinner.
Nov 12 '05 #2

P: n/a
There are samples of SpinButtons in this sample here:
http://www.lebans.com/formdimensions.htm

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Mark" <mm*****@earthlink.net> wrote in message
news:Ym***************@newsread1.news.atl.earthlin k.net...
I have autorepeat turned on for a command button that increments the value in a textbox. When I click on the button and hold the mouse button down, the value in the textbox does not change. When I release the mouse button, the value in the textbox changes to where it incremented depending on the length of time I held the mouse button down. How do I make the value "spin" in the textbox while I hold the mouse button down?

Thanks!

Mark


Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.