Replace vs. FindAndReplace

  • Thread starter Thread starter RD
  • Start date Start date
R

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
 
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
 
Back
Top