Case statement replaces some instances, but not all. Why?

M

MGM1125

I have some Case statements in a Sub function that find instances of
strings and replace them with new ones -


Case "Old Name"
rst(strField) = "New Name"


- and they work just fine. However, they skip one or two instances
sometimes. I have checked and re-checked that the "Old Name" value is
the same - spaces and all - but they still don't get changed. All of
the other ones do, it's just one or two. Any suggestions?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top