ACC2000: DblClick Event Appears to Not Work (207801)

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

REFERENCES

For more information about the DblClick event, in the Visual Basic Editor, click Microsoft Visual Basic Help on the Help menu, type dblclick event in the Office Assistant or the Answer Wizard, and then click Search to view the topic.