[AccessD] Replace Function

thanks Jim. I alredy found it --

Public Function Replace(ByRef strText As String, strSearch As String,
strReplace As String) As String
Dim lngStrPos As Long

lngStrPos = InStr(1, strText, strSearch)
    Do While lngStrPos <> 0
        strText = Left$(strText, lngStrPos - 1) & strReplace &
Mid$(strText, lngStrPos + 1)
        lngStrPos = InStr(1, strText, strSearch)
    Loop
    Replace = strText
End Function



> Check www.codehound.com
>
> HTH,
>
> Jim DeMarco
> Director Product Development
> Hudson Health Plan
>
>
> -----Original Message-----
> From: Oleg_123 at xuppa.com [mailto:Oleg_123 at xuppa.com]
> Sent: Tuesday, October 21, 2003 9:03 AM
> To: accessd at databaseadvisors.com
> Subject: [AccessD] Replace Function
>
>
> Anyone knows where I can find replace function code to use for Access 97
> ?
>
>
> -----------------------------------------
> Get Breaking News from CNN, ABC, NBC, CBS Now.
> http://www.xuppa.com/news/?link=webmail
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
> ***********************************************************************************
> "This electronic message is intended to be for the use only of the named
> recipient, and may contain information from Hudson Health Plan (HHP)
> that is confidential or privileged.  If you are not the intended
> recipient, you are hereby notified that any disclosure, copying,
> distribution or use of the contents of this message is strictly
> prohibited.  If you have received this message in error or are not the
> named recipient, please notify us immediately, either by contacting the
> sender at the electronic mail address noted above or calling HHP at
> (914) 631-1611. If you are not the intended recipient, please do not
> forward this email to anyone, and delete and destroy all copies of this
> message.  Thank You".
> ***********************************************************************************
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com



-----------------------------------------
Get Breaking News from CNN, ABC, NBC, CBS Now.
http://www.xuppa.com/news/?link=webmail