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
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?