不会吧,没有是么问题 我的是好的,你在试试Set rs = New ADODB.Recordset rs.Open "select id,mc from mz", conn, 1, 3 If rs.EOF Then Exit Sub End IfFor i = 0 To rs.RecordCount - 1 List1.AddItem ("<<" & rs.Fields("mc") & ">>")'List1.AddItem rs.Fields("mc") List1.ItemData(i) = rs.Fields("id") rs.MoveNext Next
我的是好的,你在试试Set rs = New ADODB.Recordset
rs.Open "select id,mc from mz", conn, 1, 3
If rs.EOF Then
Exit Sub
End IfFor i = 0 To rs.RecordCount - 1
List1.AddItem ("<<" & rs.Fields("mc") & ">>")'List1.AddItem rs.Fields("mc")
List1.ItemData(i) = rs.Fields("id")
rs.MoveNext
Next
改为List1.AddItem ("<<" & rst1("所借书籍") & ">>")试一下
如用trim(),Fields("...")中的所用空格将被删除
Public Function Nvl(a_vInVar As Variant) As Variant Dim l, i As Integer
Dim str As String
str = ""
If IsNull(a_vInVar) Then
str = ""
Else
str = Trim(a_vInVar)
End If
Nvl = str
End Function
list1.additem ("<<" & nvl(rst1("book")) & ">>")