Microsoft KB Archive/164788

= ACC: DblClick Event Does Not Seem to Work =

Article ID: 164788

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q164788



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



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 not to 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. Microsoft 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 prevents Windows from processing its own double-click event. For example, the following Visual Basic code and sample macro selects all the text in a text box control, and then cancels 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: Test

Action ---   SendKeys CancelEvent

Test Actions ---   SendKeys Keystrokes: {F2} Wait: No   CancelEvent



STATUS
This behavior is by design.

