Access数据库查询取值问题，为毛查询条件老被固定在一个值上面？

我的Access下面表里面ProdID1字段下面有：10000000000001 记录
在查询的时候为啥老是提示空值呢？
在监视中查看生成的SQL，条件的值怎么一直是111111？？

: SQL : "SELECT TextTable.shuzi
FROM TextTable
WHERE ProdID="11111111";
" : String : Form1.Command1_Click

代码如下：
=====================================================

    Dim DBdate As Database
    Dim MemDate As Recordset



Private Sub Form_Load()

    Set DBdate = DBEngine.Workspaces(0).OpenDatabase(App.Path & "\Text.mdb")
    
End Sub

Private Sub Command1_Click()

    
    Dim prodid3 As String
    prodid3 = "10000000000001"
    
    Set MemDate = DBdate.OpenRecordset("select * from TextTable where ProdID1 = "" & prodid3 & """)
    Text3.Text = MemDate!prodid1
    
End Sub

数据库 Access VB 查询 变量
[解决办法]
如果该字段是字符型的：（把双引号改为单引号）

Set MemDate = DBdate.OpenRecordset("select * from TextTable where ProdID1 = '" & prodid3 & "'")