Answer to Question #39960 in Visual Basic for glenn

Question

hello sir/ma'am. I really need to know this, it is possible to address all the textbox in vb.net and replace the single qoute to double qoute? because i'm having problem on inserting data in ms access.. this is my current codes :

Public Sub singleqoute()
Dim ctrl As Control
Dim txt As TextBox

For Each ctrl In ManageItems.Controls
If TypeOf ctrl Is TextBox Then
txt = CType(ctrl, TextBox)
txt.Text = txt.Text.Replace("'", "''")
End If
Next
For Each ctrl In ManageBorrowers.Controls
If TypeOf ctrl Is TextBox Then
txt = CType(ctrl, TextBox)
txt.Text = Replace(txt.Text, "'", "''")
End If
Next
For Each ctrl In ManageTransactions.Controls
If TypeOf ctrl Is TextBox Then
txt = CType(ctrl, TextBox)
txt.Text = Replace(txt.Text, "'", "''")
End If
Next

End Sub