我编写了一个简单的函数,将Access 2010中特定文本框的值输出到文本文件
Private Sub ProcessButton_Click()
MsgBox ("Into Process Button Click")
' Assign found line to variable
Dim Outline As String
Outline = Me.TextboxFound.Value
'Save record to file
strFile_Path = OutputFile
Open strFile_Path For Append As #1
Write #1, Outline
Close #1
' Update db table
' Clear Fields
Me.TextBoxPod.Value = Null
Me.TextBoxDate.Value = Null
Me.TextboxFound.Value = Null
Me.TextBoxPod.SetFocus
End Sub
我对上述代码的问题是:
Me.TextBoxFound.Value
在我的例子中,有
Me.TextBoxFound.Value = 10101010102 LINE1 DATA(CRLF)
以上内容由“findstr”命令生成。
但在输出文本文件中,我得到以下内容:
"10101010102 LINE1 DATA (CRLF)
"(CRLF)
是否有办法解决此问题,使其仅包含第一行而不包含“”?