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.
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.
Checking for special characters
0 commentaires:
Enregistrer un commentaire