deleting special chracters

hi guys,

i am having a problem in designing logic for the following problem

"I am havig a data entry form . when ever user enters the data it needs to check for special these characters ' & " ". When it finds it shld be deleted automatically i mean thru code itself"

if any body can help me out it will be great help

thanks in advance to vb guys

kalyan

u can use Replace function to replace characters.

example:

To replace & in a string str u have to use
str=replace(str,"&"," ")

VB Code:

Private Sub Text1_KeyPress(KeyAscii As Integer)
 
    Select Case Chr(KeyAscii)
        Case "&", "'", " "
            ' An ampersand, apostrophe or space was entered
            KeyAscii = 0
    End Select
 
End Sub

to delete double codes u have to use like this


str=replace(str,""""," ")

thaxs for all u guys for u r replies