spin button increase by decimal

S

Souris

I have a spin button to use for increase a value in text box by decimal.

The minimum increase is one.
I need synchronize the value user enter.
I have

Screen.ActiveControl.Value = Screen.ActiveControl.Value / 10

on text box exit.

The problem is when user go back in text box will divide one more time.

Are there any workaround for this issue?

Your help is great appreciated,
 
K

Klatuu

Move the code to the After Update event.
The Exit event fires when you leave the control whether a change has been
made or not.
The After Update event fires only when a change has been made to the value
of the control.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clearing combo boxes and a text box 2
Dynamic Naming of Form Button 3
Creating a Search using a combo box and then creating a report. 4
Word Template where user inputs <TITLE> and then that can be displayed in footers or headers [MAC] 0
Cannot Change Back to Previous Settings After Clicking "Try the new Outlook" 0
Date Time decimal value help please 1
Word macro that can call cells out of Excel for a find and replace 0
Spin Box with Dates and Lookup 5

Top