So I am trying to generate usernames and have some restrictions on what characters are used.
So I started by cleaning spaces, hyphens, and nyaas, and released I could run up against a whole lot of “accented” characters (Dealing with mostly Hispanic names but I want to cover all the bases)
So this is what I have so far that works
Code:
Me.ComputerUser = LCase(Left([FirstName], 1)) & "" & LCase(Replace(Replace(Replace([LastName], "-", ""), " ", ""), "ñ", "n"))
But is there any way to code any letter with any accent to be replaced by just the letter without the accent.
Tia
Dave