Replace vs. FindAndReplace

[RD]

On the Access Web, Alden Streeter's FindAndReplace says it "can boost
performance ..."

Does anybody know if it's really any better than VBA's native Replace function?

Thanks,
RD

 

[Alex Dybenko]

Hi,
not sure it can give you better performance, perhaps only in one mentioned
case: "string being searched is large, and the string being sought only
occurs in a few locations".
Maybe it was built in Access 97 time, when Replace function was not
available

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com