代码作法,把有效期改为数据列:http://www.foxtable.com/webhelp/scr/2494.htm
表DataColChanged事件
Select Case e.DataCol.Name
Case "生产批号"
Dim s As String = CStr(e.NewValue)
Dim d As Date =new Date(s.SubString(0,4),s.SubString(4,2),s.SubString(6,2))
d = d.AddYears(1).AddDays(-1)
e.DataRow("有效期") = Format(d,"yyyyMMdd")
End Select