I have a small function to screen for French-accented characters and replace them with unaccented English characters. It works OK for uppercase characters, but it replaces a lower-case French character with the upper-case English character.
The specified replacement character IS lower case, so it seems that VBA is making the case decision in spite of what is specified in my code.
I am attaching a small database, ReplaceProblem.accdb with one module in it that shows everything about the problem.
I am also attaching two screen shots of the erroneous results.