If (Me.Ctl"i"月.C) Then
Me.Ctl"i"月合计.C
Else
Me.Ctl"i"月合计.Ci"月])"
End If
next i
End Sub
[ 本帖最后由 su_xx 于 2008-1-22 15:34 编辑 ]作者: 咱家是猫 时间: 2008-1-21 17:39
Private Sub Form_Load()
Dim I As Byte
For I = 1 To 5
If Me.Controls("Ctl" & I & "月").C Then
Me.Controls("Ctl" & I & "月").C
Else
Me.Controls("Ctl" & I & "月").C & I & "月])"
End If
Next I
[attach]28142[/attach]作者: 咱家是猫 时间: 2008-1-21 17:42
再发一次试试
Private Sub Form_Load()
Dim I As Byte
For I = 1 To 5
If Me.Controls("Ctl" & I & "月").ControlSource = "" Then
Me.Controls("Ctl" & I & "月").ControlSource = "=0"
Else
Me.Controls("Ctl" & I & "月").ControlSource = "=sum([" & I & "月])"
End If
Next I
一来不会改变格式,二来让楼主又能手工敲一遍加强印象和记忆作者: 咱家是猫 时间: 2008-1-21 17:45
原来没看清楼主的代码,现做以修正
Private Sub Form_Load()
Dim I As Byte
For I = 1 To 5
If Me.Controls("Ctl" & I & "月").ControlSource = "" Then
Me.Controls("Ctl" & I & "月合计").ControlSource = "=0"
Else
Me.Controls("Ctl" & I & "月合计").ControlSource = "=sum([" & I & "月])"
End If
Next I