This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Download Microsoft Edge
More info about Internet Explorer and Microsoft Edge
Sets or returns the value of the
On Dbl Click
box in the Properties window. Read/write
String
.
Syntax
expression
.
OnDblClick
expression
A variable that represents a
Form
object.
This property is helpful for programmatically changing the action that Microsoft Access takes when an event is triggered. For example, between event calls you may want to change an expression's parameters, or switch from an event procedure to an expression or macro, depending on the circumstances under which the event was triggered.
The
DblClick
event occurs when a user presses and releases the left mouse button twice over an object within the double-click time limit of the system.
The
OnDblClick
value will be one of the following, depending on the selection chosen in the Choose Builder window (accessed by choosing the
Build
button next to the
On Dbl Click
box in the object's Properties window):
If you choose Expression Builder, the value will be =
expression
, where
expression
is the expression from the Expression Builder window.
If you choose Macro Builder, the value is the name of the macro.
If you choose Code Builder, the value will be [Event Procedure].
If the
On Dbl Click
box is blank, the property value is an empty string.
Example
The following example associates the
Click
event with the
OK_DblClick
event procedure for the button named
OK
on the
Order Entry
form, if there is currently no association.
With Forms("Order Entry").Controls("OK")
If .OnDblClick = "" Then
.OnDblClick = "[Event Procedure]"
End If
End With
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.