Question

VB 无效使用NULL。请大家帮帮忙！

Sub FieldtoControl(rst As ADODB.Recordset)
txtStuID.Text = Trim(rst!StuID)
txtStuName.Text = Trim(rst!StuName)
txtStuBirthDate.Text = Trim(rst!StuBirthDate)
txtStuDept.Text = Trim(rst!StuDept)
txtStuClass.Text = Trim(rst!StuClass)
txtStuFrom.Text = Trim(rst!StuFrom)
txtStuMem.Text = Trim(rst!StuMem)
If rst!StuSex = "男" Then
optSexMale.Value = 1
Else
optSexFemale.Value = 1
End If
End Sub
问题出在txtStuMem.Text = Trim(rst!StuMem)。

Answer 1

记录中有 StuMem？是否有拼写错误？

追问

记录里有的，也没拼写错误哦~

追答

所查询的记录 StuMem 没赋值？
txtStuMem.Text = Trim(rst!StuMem)改成
txtStuMem.Text = Trim(rst!StuMem) & ”“
试试