Re: Find And Replace Text String VBA

From: wadev1 (wadev1_at_discussions.microsoft.com)
Date: 09/22/04 

Date: Tue, 21 Sep 2004 21:07:02 -0700

This might be a stupid question, but given that the Table name is ADDRESS and
the Field name is STREETNAME. Would I need to place the information
somewhere in the code. I'm sure it relates to the strOriginalValue portion,
but I really dont know the proper way to edit the below code, can anyone
help? Thanks in advance.

"Ken Snell [MVP]" wrote:

> Public Function RemoveDoubleSpaces(ByVal strOriginalValue) As String
> Do While InStr(strOriginalValue, " ") > 0
> strOriginalValue = Replace(strOriginalValue, " ", " ", 1, -1,
> vbTextCompare)
> Loop
> RemoveDoubleSpaces = strOriginalValue
> End Function
>
> --
>
> Ken Snell
> <MS ACCESS MVP>
>
> "wadev1" <wadev1@discussions.microsoft.com> wrote in message
> news:A2820E1D-9891-468C-BC2B-3036F07BFA9C@microsoft.com...
> > Also, I am running Access 2000.
> >
> > "wadev1" wrote:
> >
> > > Does anyone have any code on how to replace specified text string within
> a
> > > text string? I am trying to eliminate all spaces within a Address field
> , ex
> > > 123 SAINT JOSEPH CT. I have a update query that I created that will
> give me
> > > the desired result, but I have to run it multiple times to replace all
> the
> > > spaces. I am using a InStr function to locate the Start position and
> then I
> > > concatenate the left and Mid portions (minus the space) to get the
> desired
> > > results. I have done a LTrim if the location =1 and a criteria <>0.
> How
> > > could I run the query multiple times, please give an example of some
> code?
> > >
> > > The update query, "UPDATE ADDRESS QUERY" has a select query linked to
> the
> > > actual "ADDRESS" table. The select query, "ADDRESS TEXT LOCATION" has a
> > > field "LOCATION' with a location value of the start of the text. If the
> loop
> > > could stop with the Sum of [ADDRESS TEXT LOCATION]![LOCATION] =0, that
> would
> > > be great. Thanks in advance.
>
>
>

Relevant Pages

  • Re: User Input Question
    ... point where the user will gain control? ... to loop to handle configuration for multiple machines? ... need to ask your questions inside the loop. ... "The only stupid question is the one you don't ask." ...
    (comp.lang.tcl)
  • Re: Simple loop question
    ... Hope this is not too simple or a stupid question: ... I have a slight problem with a loop. ... It is a simple numbers guessing game. ...
    (perl.beginners)
  • Re: Loop doesnt behave the way its supposed to.
    ... > Hi folks, ... A loop doesn't behave the way I'd like to (namely, ... Probably stupid question, since I was too lazy to work out the ...
    (comp.lang.c)
  • Simple loop question
    ... Hope this is not too simple or a stupid question: ... I have a slight problem with a loop. ... It is a simple numbers guessing game. ...
    (perl.beginners)