Private Sub Form_Load()
Dim ctls As Controls
Dim ctl As Control
Set ctls = Me.Controls
For Each ctl In ctls
If ctl.ControlType <> acLabel Then
ctl.OnGotFocus = "=AllOnGotFocus('" & ctl.Name & "')"
End If
Next ctl
End Sub
Function AllOnGotFocus(ctlname As String)
Dim ctls As Controls
Set ctls = Me.Controls
If IsNull(ctls(ctlname).Value) = True Then
ctls(ctlname).Locked = False
Else
ctls(ctlname).Locked = True
End If
End Function
作者: xuwenning 时间: 2010-8-17 14:36
Private Sub Form_Load()
Dim ctls As Controls
Dim ctl As Control
Set ctls = Me.Controls
For E ...
todaynew 发表于 2010-8-17 09:22