Do Until "*******************************" 3

[perrymans]

The actual text I am looking for is:

Do Until strRowValue = "*******************************"

I would like to get away with:

Do Until strRowValue Like "********"

But Like doesn't work in VBA.

How would I do this?

Thanks. Sean.

 

[JoeAtWork]

Do Until Left(strRowValue,8) = "********"

 

[perrymans]

Works for me!

Thanks. Sean.

 

[TheAceMan1]

Howdy perrymans . . .

Couldn't resist!:

[blue]   Do Until strRowValue Like [purple][b]"*[********]*"[/b][/purple][/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[perrymans]

Thanks AceMan, I take it the brackets mean an unlimited amount of *** in the middle?

So I could get away with:

Do Until strRowValue Like "*[**]*"

Thanks. Sean.

 

[PHV]

But Like doesn't work in VBA
Really ?
Could you elaborate ?

 

[perrymans]

Just that typing it hte way I had above did not return True in VBA, skipping the Loop I was trying to set off.

I had to put the exact number of ****.

I guess my point was it wasn't like SQL with

Like "*Sean*"

Thanks. Sean.

 

[TheAceMan1]

perrymans . . .

The outside characters "[red]*[/red][********][red]*[/red]" are the wild cards, the characters in brackets "*[[red]********[/red]]*" are eight actual [red]*[/red] characters, not wildcards!

As a insight into using brackets:

[blue]Search for two or more single characters in a field. You can use the [ ] wildcard with the Like operator in your queries to search for two or more single characters in a field.

For example, suppose you want to find all customers with the following ZIP codes: 08052, 08053, or 08055. To use the [ ] wildcard, enter the following in your query's Criteria row under the ZIP Code field:

Like "0805[235]"

This expression searches for all field entries whose last character matches one of the characters specified between the brackets. Conversely, to search for all customers that don't live within these three ZIP code areas, place an exclamation point before the list, as shown below:

Like "0805[!235]"

The exclamation point inside the brackets stands for Not in the list. The query results will include all entries whose characters do not match any character in the list within the brackets.

You can combine the [ ] wildcard with any other wildcard character. For example, you can combine the * wildcard character with [ ] to search for any ZIP codes that begin with 0805, 0807, or 0808:

Like "080[578]*"[/blue]

I just didn't want you to loose the connection that [blue]Like[/blue] can't be used in VBA! . . .

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[TheAceMan1]

perrymans . . .

Hit submitt too soon . . .

In your post origination . . .

[blue]Do Until strRowValue Like "********"[/blue]

. . . didn't work because [blue]you specified the wild card only![/blue] . . . which returns all!

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886