We help IT Professionals succeed at work.
Get Started

Update Delay when user clicks Checkbox

Milewskp asked
Last Modified: 2013-11-28
I have a form with two checkbox controls: YN and YN1

The control source for YN is table1.YN (a non-required boolean field), and YN1 is a calculated field: =Nz([YN],False) .

The mousedown event for YN1 is:
   Private Sub YN1_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
       Me.YN = Not Me.YN
   End Sub

The result of all of this is that YN and YN1 always have the same value, except that when YN is null, YN1 shows up as False.

Here's the question:
When the user mouses down on YN1,
 - If YN is True, then YN1 goes false immediately when the user releases the mouse.
 - If YN is False, then YN1 goes True about a second after the user releases the mouse. This delay is really irritating because it leaves you wondering if you actually clicked it properly.

Why is there a difference, and how can I make it so that the value of YN1 always changes immediately when the user releases the mouse?

Watch Question
This problem has been solved!
Unlock 1 Answer and 13 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE