MS Access VBA Control Events – PT1

In this video we are going to cover the following MS Access VBA Control Events:
Click
DblClick
GotFocus
LostFocus
DblClick
Change

This is part 1 of a 3 part video series.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
Private Sub btnClick_Click()

    MsgBox "Click"

    

End Sub



Private Sub imgDoubleClick_DblClick(Cancel As Integer)

    

    'These events fire before the DblClick event

    

    'MouseDown

    'MouseUp

    'Click

    'DblClick

    

    Me.txtDoubleClick.Visible = True

    

End Sub



Private Sub txtDoubleClick_GotFocus()

    MsgBox "Enter Password Now"

End Sub





Private Sub txtDoubleClick_LostFocus()

    MsgBox "You have left this textbox.  Continue?"

    

End Sub



Private Sub lblBookReport_DblClick(Cancel As Integer)

    'Open the Book Report

    DoCmd.OpenReport "Books", acViewPreview

    

End Sub







Private Sub txtChange_Change()

    Me.lblChange.Caption = Me.txtChange.Text

End Sub

<< MS Access Form Events – PT2 | MS Access VBA Control Events – PT2 >>

“Go Fund Me” Page

($5 suggested amount)

(…10% of your gift amount will go to charity)