Is there an IsLike? 1

[ICCIIT]

Is there an Is Like operand that can be used in module code?

I want to pass a string variable through to a function and then get the the function to evaluate it using a like statement such as you might do a in a query criteria

If MyString is like *"Hello"* then

....

End if

Thanks

 

[MajP]

http://msdn.microsoft.com/en-us/library/swf8kaxw.aspx

 

[PHV]

When in VBE put the cursor inside the Like word in your code and then press the F1 key.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[ICCIIT]

Now getting a type mismatch and yet both parts are string

I am passing the word "Current" as variable IBNRTxt

Public Function IBNRCat(IBNRtxt As String) As String
Dim Checkstring As Boolean

If Checkstring = [IBNRtxt] Like "Current" Then
IBNRCat = "Found"
End If

Any ideas why this is failing on an exact match?

 

[MajP]

No [], just IBNRtxt
If Checkstring = [IBNRtxt] Like "Current" Then

 

[PHV]

A simpler way:
If IBNRtxt Like "Current" Then
IBNRCat = "Found"
End If

Anyway, why using the Like operator with NO wildcar ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[ICCIIT]

Thanks to you both... just one more step (I think)

PHV you are too psychic for your own good!

The wildcard question was coming next I just wanted to get a working result on an exact match first before moving on to that.....

So now this is working, I want to pass "Curr" and get a true result

The Access help notes on this are not very clear about wildcards..

 

[PHV]

If IBNRtxt Like "Curr*" Then

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[ICCIIT]

PHV
I thought I had tried that and it failed.... I just did it again and its fine!!

Thats great thanks very much and a Friday start for U

 

[ICCIIT]

ooohps "Star" not start...