access的类模块?
在vba里定义了一个类模块,初始化及调用都正常
最后  “Set m_窗体 = Nothing ” ‘m_窗体 是类的实例
Private Sub Class_terminate() 这个销毁函数并没有被调用?什么原因啊?
------解决方案--------------------
可以调用
类模块:
'类名称为: clsTest
Private strUserName  As String
Public Property Let UserName(ByVal UserName As String)
   strUserName = UserName
End Property
Public Property Get UserName() As String
   UserName = strUserName
End Property
Private Sub Class_Initialize()
 strUserName = "ewang11"    
End Sub
Private Sub Class_Terminate()
  MsgBox "类已被Terminate"
End Sub
窗体代码
Dim a As New clsTest
Private Sub Command0_Click()
 MsgBox a.UserName
End Sub
Private Sub Command1_Click()
  Set a = Nothing    '销毁类,会触发Terminate事件
End Sub