rk4088 0 Newbie Poster

I'm having a textbox in my form. I'm using tc table with field description.

description
-----------
AAA
BBB
CCC
DDD

if i externally insert the field as E.E.E
and then if i add EEE in my textbox it should made a info thro msgbox like 'description already exists'

how to do this..
give some coding..

i've done stripping special character function like this

Public Function strip(ByVal des As String)
        Dim strorigFileName As String
        Dim intCounter As Integer
        Dim arrSpecialChar() As String = {".", ",", "<", ">", ":", "?", """", "/", "{", "[", "}", "]", "`", "~", "!", "@", "#", "$", "%", "^", "&", "*", "(", ")", "_", "-", "+", "=", "|", "", "\"}
        strorigFileName = des
        intCounter = 0
        Do Until intCounter = 29
            des = Replace(strorigFileName, arrSpecialChar(intCounter), "")
            intCounter = intCounter + 1
            strorigFileName = des
        Loop
        Return strorigFileName

    End Function

please do help

Thanks in advance

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.