This is a discussion on VBA Replace Function with WildCard within the Microsoft Access forums, part of the Question Forums category; I want to use the replace function in VBA to do a wildcard search. Seems like I've been able to ...
I want to use the replace function in VBA to do a wildcard search. Seems like I've been able to do this before but am having the hardest time remembering how.
x = "test"
still prints "test" instead of "hi"
I tried this:
x = "t*t"
and got "hi" returned. Which looks like it does not accept wildcards. I did not see any wiggle room for wildcards when I read the Help topic. Could it have been something that also incorporated the "Like" keyword?
Sorry I can't help, but still wanted to encourage you to keep looking. It looks like it will be useful if you find a way to do it.