用代码给树字体加颜色
时 间:2015-07-27 08:35:10
作 者:杜超 ID:16058 城市:江阴
摘 要:树控件属性里没法改字体颜色,但可以用代码来实现,如下图。
正 文:
图 示:
代 码:
Private Sub Form_Load()
Dim rststudent As DAO.Recordset
Dim strkey As String, strText As String
Dim strgrade As String, strclass As String
Dim nodgrade As Node, nodclass As Node, nodstudent As Node '后来增加定义颜色用
Set rststudent = CurrentDb.OpenRecordset("select * from 表1 order by 表1.学生学号")
With rststudent
If .EOF Then Exit Sub
.MoveFirst
Do Until .EOF
strgrade = !年级
strclass = !班级
If nodeexist(Me.tvwcommon.Object, strgrade) = False Then
'增加年级节点
Set nodgrade = tvwcommon.Nodes.Add(, , strgrade, strgrade, "Grade")
With nodgrade
.ForeColor = vbRed '给字体加颜色
.Bold = True
End With
End If
If nodeexist(Me.tvwcommon.Object, strgrade & strclass) = False Then
'增加班级级节点
Set nodclass = tvwcommon.Nodes.Add(strgrade, tvwChild, strgrade & strclass, strclass, "Class")
With nodclass
.ForeColor = vbBlue
End With
End If
'增加学生节点
Set nodstudent = tvwcommon.Nodes.Add(strgrade & strclass, tvwChild, "K" & !学生学号, !学生学号 & " " & !学生姓名, "Student", "Selected")
With nodstudent
.ForeColor = RGB(200, 30, 50)
.BackColor = vbCyan
End With
.MoveNext
Loop
End With
exithere:
rststudent.Close
Set rststudent = Nothing
Exit Sub
errorhander:
MsgBox Err.Number & Err.Description
GoTo exithere
End Sub
Access软件网QQ交流群 (群号:483923997) Access源码网店
常见问答:
技术分类:
源码示例
- 【源码QQ群号19834647...(12.17)
- 【Access窗体导出PDF】...(04.08)
- 【Access窗体导出PDF】...(04.07)
- Access两种方式实现即时更...(03.01)
- Access隐藏与显示lacc...(01.12)
- 【Access高效办公】将每个...(12.23)
- Access21点游戏源代码(12.13)
- 【Access窗体导出Exce...(11.15)
- 【Access开发】Acces...(11.14)
- 通过Access宏录入数据到选...(11.10)
学习心得
最新文章
- ACCESS精华集锦资料.CHM(04.25)
- Access VBA语句If Me...(04.24)
- 【Access修改记录示例】编辑选...(04.22)
- 【Access表名称命名建议】将A...(04.20)
- Access学习笔记--用Acce...(04.19)
- 【Access重复项查询示例】将A...(04.17)
- Access快速开发平台企业版--...(04.16)
- 【Access模块示例】通过模块代...(04.15)
- Access查询里面分组合计功能添...(04.13)
- 【Access删除查询】删除数字最...(04.12)