ACC: DblClick Event Does Not Seem to Work

• Microsoft Access versions 7.0, 97

SYMPTOMS

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

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.

REFERENCES

For more information about the DblClick event, search the Help Index for "DblClick event."