A little redundant but if it works...  Good job.

There is an example in the Code Vault - IsFound Any Char in String  that is a little more compact and you can also check things like upper and lower case etc.  Good for passwords as well.

The video showing how that was created:  String Functions

Thanks Scott,
The main difference between the code you point to and ours is that we actually remove the special characters to enable the revised name to form part of the .pdf filename (along with a date/time stamp).
I can see the value in both methods though, depending on what the objective is.... Thanks again......

Hi William,

I use this code for my contact names. It essentially lists what IS allowed, rather than what isn't!

Is Not Null And Not Like "*[!-A-Z']*"

Breaking this down:
Is Not Null - Speaks for itself, can't be blank
*[!-A-Z']* - Put in here the characters you want to allow. I'm allowing A thru to Z, - and ' which allows for names like anne-marie and O'Sullivan.

That includes spaces and numbers too! I.E. no spaces and no numbers allowed. Just edit it to requirements

William -
My bad I should have qualified my statement above a little better. The thing about the one line code you presented above will catch the first occurrence of any of the characters you have in your string then go on.  What happens if more than one of your disallowed characters are in your string?
The function I pointed you to above shows you how to loop through the whole string to ensure you don't have ANY of those characters.
What you do with those characters is up to you.

Dan Jackson just gave you a great example above on how to shorten down your code.

The only difference between the two codes is that Williams will automate the process after the name is entered whereas mine will actively stop the user from typing the name so they can't physically type the special characters

True.  But what if it is not being typed in?  An import for instance.  That would cause errors instead of correcting the file name for the import.

Scott,
In this particular case it would be extremely unlikely for a ContractorName to contain more than one special character so the solution we implemented will work fine but I take your point, in a different scenario your method, or Dan's, would be the way to go with some modifications to remove the character(s) in question. We have situations where the ContractorName with a special character is valid (e.g. T/A Electrical, Inc.) so we have to modify the .pdf name and leave the Contractor name as entered.
Fascinating stuff though, (I love the different solutions that occur to different developers). Skinning a cat comes to mind. Lol

What you want is Filter Characters