Tony Septav
TSeptav at uniserve.com
Sun Feb 26 09:35:09 CST 2012
Hey All
Some code that may help. Didn't want to try writing tons of code for all the
reserved words, so I use this code, nothing fancy by any means but it seems
to be working fine. Except for multiple asterixs. Search for everything
containing *** and it returns **a, ***b, ****d, *e*, ***f*** etc. Not a
biggy because I can see the asterixs. Also I am getting tired of fooling
around with this thing.
If Mysearch=1 ..........Starts With
If Len(Me!MyPhrase = 1 Then
Zimbo = "[" & Left(Me!MyPhrase, 1) & "]" & "*"
Else
If Len(Me!MyPhrase) = 2 Then
Zimbo = "[" & Left(Me!MyPhrase, 1) & "]" & "[" & right(Me!MyPhrase,
1) & "*"
Else
Zimbo = "[" & Left(Me!MyPhrase, 1) & "]" & Mid(Me!MyPhrase, 2,
Len(Mid(Me! MyPhrase, 2)) - 1) & "[" & Right(Me!MyPhrase, 1) & "]"
& "*"
else .........Contains
If Len(Me!MyPhrase = 1 Then
Zimbo ="* & "[" & Left(Me!MyPhrase, 1) & "]" & "*"
Else
If Len(Me!MyPhrase) = 2 Then
Zimbo ="*" & "[" & Left(Me!MyPhrase, 1) & "]" & "[" &
right(Me!MyPhrase, 1) & "*"
Else
Zimbo ="*" & "[" & Left(Me!MyPhrase, 1) & "]" & Mid(Me!MyPhrase, 2,
Len(Mid(Me!MyPhrase, 2)) - 1) & "[" & Right(Me!MyPhrase, 1) & "]" & "*"
End If
MyWord = Zimbo