Microsoft KB Archive/207801

= ACC2000: DblClick Event Appears to Not Work =

Article ID: 207801

Article Last Modified on 6/24/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q207801



Moderate: Requires basic macro, coding, and interoperability skills.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).



SYMPTOMS
Certain actions you perform in the DblClick event of a form control do not appear to do anything. For example, if you set the OnDblClick property of a text box control to a macro or Visual Basic procedure that is supposed to select all of the text in the control, it appears to not work correctly.



CAUSE
When you double-click a word in Microsoft Access and in many other Windows applications, the word you double-click is selected. Access processes the event procedure or macro for the DblClick event, and then Windows selects the word you double-clicked. This makes it appear as though the code or macro did not run.



RESOLUTION
You can cancel the DblClick event after it executes your Visual Basic code or macro. This action prevents Windows from processing its own double-click event. For example, the following Visual Basic code and sample macro select all the text in a text box control, and then cancel the DblClick event.

In a Visual Basic for Applications Procedure
Private Sub Text1_DblClick(Cancel As Integer) SendKeys "{F2}" Cancel = True End Sub

In a Macro
  Macro Name    Action         Action Arguments -    Test        SendKeys       Keystrokes: {F2} Wait: No                CancelEvent

