Hi to everyone in the Newsgroup,

I have a question that I really don't known how to solve.
To handle names with mixed cases, on my form, I'm using the code I
found at this web-link: http://www.mvps.org/access/strings/str0008.htm
Of course, it works great and as I read it should be modular so that
it possible to add additional rules to handle special sequences of
characters.

What I'd like to do is to add a piece of code, to be able to
transform the string ''spa'' in ''S.p.A.''
My trouble is that any time I have to write S.p.A. and I do that
hundred of
times, I have to remember to hit the point key after each letters and
at
same time I have to mind the different case of each characters .
It will be great if it doesn't matter how I to write ''spa'', the code
would change it in ''S.p.A.'' for me.
Looking the last part of the code there is a function to handle
roman numbers. So any time you write ''vii'' the code will change in
''VII'' for
you.
Is possible to do something like that for my sequences of words?
I'm not absolutely able to that, so I'm asking for help.
The words I'd like to be able to handle are: S.r.l. S.p.A. s.n.c.
s.a.s. S.r.l.u.
They are often (not always) located at the end of any strings

I hope you will be give to me an hand.....!
Thanks,
Stefano.