Checking for special characters

[Boolean]

I want my to detect special characters in my descriptions that are not found on keyboard and display as error.
Tried using the following

Description check: IIf([Common Description] Is Null Or [Common Description] Not Like "*[!a-z0-9@=.^_$%!#&'`(){|}*?~[]/\-]*" And [Description Local] Is Null Or [Description Local] Not Like "*[!a-z0-9@=.^_$%!#&'`(){|}*?~[]/\-]*","<<Error Desc>>","OK")

but when i tested it using some data, it shows all as <<Error Desc>>
some of the special characters i want to check for are βµΩ etc.
so if my description contains characters that are not: a-z OR 0-9 or any of the following ~!@#$%^&*()_+=-`\][';/.,<>?:"{}|~

it will return <<Error Desc>>

Any help would be appreciated. I have never touched access before and this work is to continue where the previous guy left off.

Pardon if my query is unclear.

 

[Boolean]

Or are there anyway to check by creating an additional table to check letter by letter for characters/letters that are allowed.

 

[Mile-O]

Something like this.....?

There's two examples in there. One on a form, detecting special characters as you type; and the second used in a query to determine if some text has special characters or not.

 

[Boolean]

Something like this.....?

There's two examples in there. One on a form, detecting special characters as you type; and the second used in a query to determine if some text has special characters or not.

i wont be keying in the data manually. would be importing a tab delimiter text file. And i have a query to check for some stuff but now i need to add in the character check.

 

[Mile-O]

i wont be keying in the data manually. would be importing a tab delimiter text file. And i have a query to check for some stuff but now i need to add in the character check.

It's the same principle in that each method - my two, and your own problem - all use the same function.