Fix Access object executing
While MS Access is executing code during the object's event, all other events of the object are locked, so they will not be fired.
Let's say we have the Microsoft Calendar Control 8.0 ( mscal.ocx ) placed to a form and we have the code:
Private Sub Calendar1_Click()
Calendar1.Month = 1 + (Calendar1.Month) Mod 12
Private Sub Calendar1_NewMonth()
MsgBox "Calendar1_NewMonth event" & Calendar1.Month
The sample should displays a message box when the user clicks the control. In MS Access, the message box never occurs, as the NewMonth event is called during the Click event. If the exactly the same code is called on VB6, VB/NET the MessageBox is shown each time the user clicks the control. In conclusion, the MS Access can not handle events inside other events.
Gerrit Viehmann commented
While I think the proposed behavior is reasonable, it would break a lot of my current code. So am against it.