标题: 关于通过编程ValidationRule设置有效性规则的用法 [打印本页] 作者: guoya 时间: 2004-2-15 22:07 标题: 关于通过编程ValidationRule设置有效性规则的用法 我在模块中编制了一个函数
Public Sub SetFieldValidation(frm As Form, _
strContrName As String, strValidRule As String, _
strValidText As String)
Dim contr As Control
Set contr = frm.Controls(strContrName)
contr.ValidationRule = strValidRule
contr.ValidationText = strValidText
End Sub
然后在窗体的form_load中引用
Call SetFieldValidation(Me, "ID", "<500", "对不起,你只能输入500条记录")