alistercruickshanks
New member
- Local time
- Today, 22:35
- Joined
- Feb 13, 2017
- Messages
- 6
Hi,
I am struggling trying to check if a textbox contains characters that are Not A-Z, or a-z or a Hyphen or a Space
Our access system exports names to an accounts system that breaks if a foreign character is in the name, like accents.
The solution would be to warn users with a msgbox popup..... that the name contains such characters
The textboxes are autofilled by extracting data, so I don't want to use a mask, but use code to check after we export.
So.... If I am looking for
If [textbox name] is Not Like..... then
msgbox
End if
I have tried a varierty of code, but I think most is for ASP..NET or SQL
If anyone has any soltion for VBA would be great.
So... Only allow letters in upper or lower case, or spaces, or hyphens (for double barrel names). Otherwise warn the user with a popup.
Thank you.
I am struggling trying to check if a textbox contains characters that are Not A-Z, or a-z or a Hyphen or a Space
Our access system exports names to an accounts system that breaks if a foreign character is in the name, like accents.
The solution would be to warn users with a msgbox popup..... that the name contains such characters
The textboxes are autofilled by extracting data, so I don't want to use a mask, but use code to check after we export.
So.... If I am looking for
If [textbox name] is Not Like..... then
msgbox
End if
I have tried a varierty of code, but I think most is for ASP..NET or SQL
If anyone has any soltion for VBA would be great.
So... Only allow letters in upper or lower case, or spaces, or hyphens (for double barrel names). Otherwise warn the user with a popup.
Thank you.