Private Sub SetListView1()
' ListView1.View = lvwList
ListView1.GridLines = True
Dim xItem As ListItem
ListView1.ListItems.Clear
rs.MoveFirst
Do While Not rs.EOF
Set xItem = ListView1.ListItems.Add
With xItem
.Text = Trim(rs.Fields("id"))
' .SubItems(1) = Trim(rs.Fields("Text"))
(运行到上面这句时出错,说是无效的属性值)
End With
rs.MoveNext
Loop
End Sub哪错了呢,单独运行.text是正确的
' ListView1.View = lvwList
ListView1.GridLines = True
Dim xItem As ListItem
ListView1.ListItems.Clear
rs.MoveFirst
Do While Not rs.EOF
Set xItem = ListView1.ListItems.Add
With xItem
.Text = Trim(rs.Fields("id"))
' .SubItems(1) = Trim(rs.Fields("Text"))
(运行到上面这句时出错,说是无效的属性值)
End With
rs.MoveNext
Loop
End Sub哪错了呢,单独运行.text是正确的
' ListView1.View = lvwList
ListView1.GridLines = True
Dim xItem As ListItem
ListView1.ListItems.Clear
rs.MoveFirst
Do While Not rs.EOF
Set xItem = ListView1.ListItems.Add(, , Trim(rs.Fields("id")))
'xItem.SubItems(1) = Trim(rs.Fields("Text"))
rs.MoveNext
Loop
End Sub'看行不行。
2、rs.Fields("Text")) 是否为 null 值?可换成
.subitems(1)=iif(IsNull(rs.Fields("Text")),"",trim(rs.Fields("Text")))
lisvview1.ColumnHeaders.Remove i '减去第 i 列